Hi,
I'm looking for a formula that returns the number of entries that are both visible and unique from a filtered column. In the attached example ( Count unique and visible entries.xlsx ) I want a formula for cell b23 that returns the number of unique individuals that are bankers... the answer should be 4.
One constraint: I need to avoid adding additional columns.
I appreciate any help anyone has to offer.
- Kajakk
An easy way without complicated formulas is this one.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
I didn't noticed that....One constraint: I need to avoid adding additional columns.
ARRAY formula.
=SUM(IF(FREQUENCY(IF(SUBTOTAL(3,OFFSET(B5,ROW(B5:B21)-ROW(B5),,1)),IF(B5:B21<>"",IF(C5:C21="Banker",MATCH("~"&B5:B21,B5:B21&"",0)))),ROW(B5:B21)-ROW(A5)+1),1))
Thank you for your quick response!
Now I know what I should do next:-)
//kajakk
.......................
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks