davidhall80
Well-known Member
- Joined
- Jul 8, 2006
- Messages
- 663
I need to get a count of unique Employee IDs, The only problem is I can't use the formula below that I've been using because there is an active filter on column B. Is there a way to get a unique count on a filtered list.
SUM(IF(FREQUENCY(A2:A100,A2:A100)>0,1))
Thanks in advance
SUM(IF(FREQUENCY(A2:A100,A2:A100)>0,1))
Thanks in advance