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

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

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

Absolutely informative and useful! Thanks!!!

Pivot table is awesome. Thanks for sharing this info.

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

This was very helpful and informative. Thank you.

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

Thank you! This is exactly what I needed

Thanks, my friend! Simple and useful

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

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

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

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 😂

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

Top notch - Thank you!

Excellent! Thanks very much!

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.

How can I count these unique values on another sheet

Great. Thanks

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?

thx!

thank u