Can SUBTOTAL count the unique values in a filtered table?

[goncalogera]

I've looked around a few threads but was unable to find a solution to my problem. How can I count the unique values that appear in a filtered table? Can

SUBTOTAL()

do this?

Thank you!

 

[mamady]

Hi Dear,

Have you tried =UNIQUE( ) ? where the filtered range is between the brackets

Best Regards

 

[Fluff]

The Subtotal function will not do what you want, have a look here

Count Unique Items in Excel Filtered List - Contextures Blog

You can use the SUBTOTAL function to count visible items in a filtered list. In today's example, AlexJ shows how to count the unique visible items in a

contexturesblog.com

Or here

Count Unique values in a filtered Column

I have people's names in Cells A9 to A42 and I want to count the number of unique people in the list so I can multiply the number of unique people by 40 and give me the total # of hours I have available in a week given a 40 hour work week. I came up with the following formula which works great...

www.mrexcel.com

@mamady the OP is on 2019 so does not have the Unique function.