Count Unique Values visible in a filtered table


I need to count the nuber of unique values visible in a filtered table.

I can count the visible values in a filtered list with the formula


And count the unique values in the table with the array formula


But haven't been successful in combining them.

Anyone have a solution to Counting Unique Values visible in a filtered table?



Selected Answer

Here is a pretty gnarly formula. It currently assumes the headers are in row 1 and the data to count starts in cell A2 and goes down.


It's an Array formula and you need to Enter it usingĀ Ctrl+Shift+Enter

(found this somewhere on the web and adapted it a bit)



Thanks Don.
Took me a little while to wrap my head around it and addapt to my use.
Dragonhead (rep: 2) Feb 1, '17 at 9:02 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login