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 😂
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?
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!
I have been searching for this forever! I'm about to start asking a lot of questions.
THANK YOU VERY MUCH! IT'S BEEN QUITE HELPFUL!
Thank you! This is exactly what I needed
This is great, is there a way to now remove duplicates and still keep the count of how many times it had reoccurred ?
Pivot table is awesome. Thanks for sharing this info.
Many thanks - this is exactly what I was looking for ;)
Glad to hear it Omer :)
Great presentation! How can you, if possible, have pivot table include showing the 5 emails (abc1, abc4, abc11, etc.)? Thanks
This was very helpful and informative. Thank you.
Absolutely informative and useful! Thanks!!!
Excellent! Thanks very much!
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 😂
Top notch - Thank you!
Thanks, my friend! Simple and useful
Why didn't i see this before I took the exam today! Huhuhu
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.
thx!
thank u
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?
same problem, have you solved it?
How can I count these unique values on another sheet