Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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