Excel - Do a Count of Unique Values | Text and/or Number | Get a Count of Unique Values in Excel

[@Alebobb]

THAT SUMPRODUCT FORMULA IS F GOLD! THANKS A LOT

[@dbmnfinity1]

Thank you, I have been searching online forever to find this

[@javidiaz7071]

Marvelous just what I was looking for. Thank you.

[@jacobm7026]

What about when you want to count the unique values in 1 column based on meeting a requirement in a different column?

[@UjangBoyor]

idk if you have the answer for this but the =COUNTIFS formula do work for me. The full Formula is =COUNTIFS([criteria_range1],criteria,[criteria_range2],criteria2,etc] Example =COUNTIFS(B2:B1000,A2)

[@IvanCortinas_ES]

Excel365 - More or less fast formula (artificial intelligence). You're a machine. Old school Excel - Think, analyze the problem, formulate with mathematical tricks or the like. You are a human being. Thank you Chester for this comparative!

[@ChesterTugwell]

Profound! Which do you prefer?

[@IvanCortinas_ES]

@@ChesterTugwell No doubt, 365, but the essence of the original Excel has been lost.

[@AmbutuMalone]

THAN YOU! YOU MADE MY LIFE SO MUCH EASIER!

[@73true]

You make my life easy Thanks

[@alitamine7699]

Thanks so Much, very smooth Explanation !

[@ChesterTugwell]

Glad it was helpful!

[@HardenTheGift]

A nice math session here. I'll take option 2!

[@HarrissonMkristo]

Thank you ... this has made my day !

[@nedisyadani]

i got error #div/0! in output column...what does it mean? need help, thanks

[@BettyO-777]

Superb, you have made my day:)

[@mahaalammar968]

Thanks you save my day 😂

[@patrickschardt7724]

365 made the challenging very easy. It’s neat to see how this used to be done

[@ion669]

Hi I am trying to achieve this but with two columns. I have a huge list of vendors in [column b] and in [column c] I have different codes that can be repeated for the same vendor depending on the date. Now I made a [column a] where i want to show the distinct code values specific for each vendor. I can achieve a unique value for one column no problem but how do i tell excel that i want it to: based on the value of b, count the unique code values that only applies to that vendor and not spill through the other vendors I might have. So for example I can make a pivot table out of the data adding it to the data model and then i place the vendorson rows and codes on values (then making them distinct) and i get each vendor with the unique count of codes for each and if i double click i get the list with all the information but that dont work for my purposes becasue excels makes a new sheet for me to be able to see the information whereas would be better if i have the distinct next or before the vendor in the complete data. Just in case, Im using excel 365. Thank you for the video and explanation it was very easy to understand.

[@marcorivera7433]

thank you sir so easy to understand

[@stelatarcila9498]

you are so wonderfull!! thanks!

[@mubashir38]

It works well but give #DIV/0! error if there is a blank row

[@ciprianmihai4821]

Thank you for this formula. Please help me. How do i subtotal this on 365?

[@jennadar6517]

Thank you this was so useful!!

[@raibishwa]

Thanks a lot, it is more useful than ChatGBT

[@CreativeDev]

Superb video

[@CCAFO]

Hello, if you can show how to count only one if there are the same value in other cell

[@amarendrabehura1266]

Hi, I have two worksheet, I want count unique value based on column match criteria

[@AshokX985]

Awesome, to the point.

[@snchitre]

How to count unique rows with one more filter condition in a table?

[@sewingmachine5467]

Thank You, these seem to be the best explanations I have found. Understood them and applied them both well. However, I need this function (I have tried the COUNTA version) within the SUBTOTAL feature, but Excel give me an error. Can anyone please help ?

[@divyanshchaudhary7063]

Does it consider Blank spaces also?

[@PoGoTips]

Thanks so much

[@surennair2926]

How would you add another criteria. e.g if you had another column which had yes or no. How would you work out the unique value for the Yes/no

[@JJ_TheGreat]

I did like looking at the old formula way, btw! How does that work - from a mathematical standpoint? Thanks.

[@TheNayanshetty]

Thanks

[@haro1059]

The formula gives an error if empty cells are selected. Is there a variant that ignores empty cells?

[@dasikowl]

how to add unique names in older version

[@moesadr3342]

Can someone please explan how we also can the get the number of repeats for each unique value? Similar to Countif to ge the total number of each value within a coulumn? Let's say first coulmn shows each unique value exactly per the cell values, then the second shows how many of each are in that coulmn? Thank you!

[@mikesara7032]

I'm trying to figure out how to count the amount of times the number changes, for example in column A i have 252 values of 7 and 8, 7 = 73 and 8 = 178, what i want to do is see the number of times the values changes from 7 to 8, i did it manually and it came up to 49 times, but i would like to know what kind of function can i use for such task, can you please help me?

[@dbmnfinity1]

I don't know if this question has been asked, how can you count name in excel.....ex: I have 200 reps and I need to track how many survey's they have completed. John has 47 , Jane has 20 and Paul has 78. there name will be entered individually..... how can I create a running total of them please.

[@mdmahadihasan7296]

UNIQUE COUNT Without Blank Cell? Is It Posible

[@User-bu6tu]

Both methods won't work if you have blank cells in your table. For method 1 it will return DIV/0!; for method 2 it will count blank cell as a unique value, and add it to the count returning an incorrect result.

[@gekalskip]

=COUNTA(UNIQUE(D15:D94)) this works for me with blank cells

[@fawoleadeolu8648]

You smart! Still trying to find a way round that

[@professordrabhijitsayamber2299]

Om pure and applied