Count Occurrences of Unique Values in a List in Excel

[@kimpedersen]

5 year old video and still PERFECT for what i needed. Thank you very much :)

[@dbmnfinity1]

I have been searching for this forever! I'm about to start asking a lot of questions.

[@joesim9577]

This was very helpful and informative. Thank you.

[@mattritchie75]

I'm confident in doing this and also using subtotal/aggregate make totals apply only to filtered rows for SUM and COUNT functions. I have been going absolutely insane all day however trying to get my unique countA to adjust when I filter as my subtotals do. I cannot get this function to work with subtotal/aggregate. Essentially I have a list of names in columm A (which I have unique count set on as individuals can appear more than once). I then have various filters of other selections along columns through to S. As I filter them, their subtotals adjust but the unique count on column A stays the same. Help please!! Otherwise I may shortly need both a new computer and office window 😂

[@marial.6005]

how do i count each word in a list of phrases to make a tally of each? Each cell has 3 to 5 words. I want to count each word and get a tally of each.

[@deansservices3724]

Clear, informative, and just what I was looking for. Liked & subscribed!

[@arkobhowal7904]

You almost saved me from a daylong tiring work. I can’t thank you enough for this. Just love u❤❤❤.

[@MrNess2911]

THANK YOU VERY MUCH! IT'S BEEN QUITE HELPFUL!

[@calgrizzlybear2982]

Great presentation! How can you, if possible, have pivot table include showing the 5 emails (abc1, abc4, abc11, etc.)? Thanks

[@Matt333ETH]

Thank you! This is exactly what I needed

[@mauro_mirez]

Absolutely informative and useful! Thanks!!!

[@OmerBoehm]

Many thanks - this is exactly what I was looking for ;)

[@TeachExcel]

Glad to hear it Omer :)

[@eliaskadri1405]

This is great, is there a way to now remove duplicates and still keep the count of how many times it had reoccurred ?

[@spm4391]

Why didn't i see this before I took the exam today! Huhuhu

[@riacollins7572]

Excellent! Thanks very much!

[@AbhijithMulavana]

Pivot table is awesome. Thanks for sharing this info.

[@sheetalbarapatre6808]

I want the count of values that are duplicate in a column, it should be displayed only in one cell. Means i want the count of those values occurring more than once in the dynamic column, and the count should be displayed in one cell. Can you please help?

[@siyabongagift4168]

same problem, have you solved it?

[@payal5366]

How can I count these unique values on another sheet

[@mikeprezymirsky7530]

Thanks, my friend! Simple and useful

[@robertsobczak1461]

Top notch - Thank you!

[@frogboy831]

thx!

[@dinahany233]

thank u

[@vigilhammer]

Great. Thanks