I have a VBA macro that will autofilter the sheet based on criteria,
I then need to get a count of all the unique values in range (BS2:BS1000) in the cells visible after the autofilter.
How would I do this?
I have a VBA macro that will autofilter the sheet based on criteria,
I then need to get a count of all the unique values in range (BS2:BS1000) in the cells visible after the autofilter.
How would I do this?
One way would be using Dictionary,
Please Login or Register to view this content.
Try this array formula
Press Ctrl + Shift + EnterPlease Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Try this UDF function
To use itPlease Login or Register to view this content.
Please Login or Register to view this content.
Nice Yasser!!
Another option, looping only through visible cells,
Please Login or Register to view this content.
No loop
Referenced formula.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks