Hi, I am using the following formula to count unique cells:
SUMPRODUCT(1/COUNTIF($B$2:$B$708;$B$2:$B$708))
Now I want to count unique cells after filtering the cells, can some one please help me.
thank you!!!
Hi, I am using the following formula to count unique cells:
SUMPRODUCT(1/COUNTIF($B$2:$B$708;$B$2:$B$708))
Now I want to count unique cells after filtering the cells, can some one please help me.
thank you!!!
see this thread:
http://www.excelforum.com/excel-form...ed-column.html
997
Last edited by icestationzbra; 12-12-2012 at 07:27 PM.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
Thank you!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks