countif for unique values, in filtered rows

[Hansulet]

I need a formula to count unique values in a column for filtered rows

 

[Aladin Akyurek]

I need a formula to count unique values in a column for filtered rows

Let's say that we want to run a unique count on E5:E22 while AutoFilter is active..

E1, control+shift+enter, not just enter:

=SUM(IF(FREQUENCY(IF(SUBTOTAL(3,OFFSET(E5,ROW(E5:E22)-ROW(E5),0,1)),
    IF(E5:E22<>"",MATCH("~"&E5:E22,E5:E22&"",0))),ROW(E5:E22)-ROW(E5)+1),1))

 

[Hansulet]

Thanks, it is perfect.

 

[Aladin Akyurek]

Thanks, it is perfect.

You are welcome.