Count Occurrences of Unique Values in a List in Excel

How to get all of the unique values from a list and count how many times they occur within a master list of values.

This tutorial covers multiple methods to get unique values of lists, including using built-in Excel functions, PivotTables, and how to use formulas and functions to count the occurrence of those values.

[arkobhowal]

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

[kimpedersen]

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

[dbmnfinity]

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

[MrNess]

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

[MattETH]

Thank you! This is exactly what I needed

[deansservices]

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

[OmerBoehm]

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

[AbhijithMulavana]

Pivot table is awesome. Thanks for sharing this info.

[mauro_mirez]

Absolutely informative and useful! Thanks!!!

[joesim]

This was very helpful and informative. Thank you.

[eliaskadri]

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

[calgrizzlybear]

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

[mattritchie]

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 😂

[spm]

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

[marial.]

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.

[payal]

How can I count these unique values on another sheet

[sheetalbarapatre]

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?