موزیک اس ام اس و جوک نرم افزار دل نوشته

How To Count Unique Values In A Filtered Column In Excel?

If you have a list of names which populated with some duplicates in a filtered column, and now, you want to count the number of unique names only from this filtered list. Do you have any good solutions to quickly deal with this job in Excel?

Count unique values in a filtered column with array formula

Count unique values in a filtered column with Kutools for Excel

 Count Unique Values In A Filtered Column With Array Formula

Amazing! Using Efficient Tabs In Excel Like Chrome, Firefox And Safari!

Save 50% Of Your Time, And Reduce Thousands Of Mouse Clicks For You Every Day!

The following array formula may help you to solve this task quickly and easily, please do as follows:

Enter the following formula into a blank cell where you want to put the result:=SUM(IF(FREQUENCY(IF(SUBTOTAL(3,OFFSET(D2,ROW(D2:D22)-ROW(D2),,1)), IF(D2:D22<>"",MATCH("~"&D2:D22,D2:D22&"",0))),ROW(D2:D22)-ROW(D2)+1),1)), and then press Shift + Ctrl + Enter keys together to get the correct calculation, see screenshot: