How to Count Unique Text Values in a Range in Excel

[Jonanism]

Thank you so much. For some reason, I could understand what others were trying to explain. Great job!

[matthewpapachristodoulou]

This was so much simpler and accurate, I watched a few other videos but they were telling me to just use sum not sumproduct

[davidwill]

Thank you! What a great solution for this.

[brettmiller]

Looked for a simpler way of doing this than using Frequency() for a while...This is much easier to understand/explain, Thank you!

[roberthemsley]

How to do add a criteria to this? In this example, number of unique names that have scored 7 points

[richcastline]

I just want to say... Thank You Kevin. Other videos where a bit complicated, lengthy and as you pointed out... unnecessary.

[deadraque]

nope not working with mine is =SUMPRODUCT(1/COUNTIF(E9:E94, E9:E94)) but stays on formula

[MrNaturalcure]

What if multiple rows has different profuct SKUs if we can count those and use to check how much sold out from record

[dippyk]

Hi Miller, I am trying to use this formula for 22000 rows and this aint working, Can you please help resolve. Thanks, DP

[JohnZeBags]

Do we need to modify the formula if it's being entered into a cell not on the same row as the top value?

I'm trying to do something similar but with the formula below the dataset, instead of next to it. I get an error when I follow these steps (#DIV/0!)

[xj]

What should I do if I wanted to only display the count of unique texts after I do some filtering

[soltjee]

For me it only works when my range doesn't have any blank cells, so if it doesn't work for you that might be why

[remmade]

I just tried this on a Pívot data and it’s not working😭😭😭