count unique values with auto-filter on
Hello,
I'm trying to count unique numbers in a resulting list after filtering. I
have already learned how to count unique number in an unfiltered list using:
=SUM(IF(FREQUENCY($A$12:$A40,$A$12:$A40)0,1))
but now I need to know how many unique numbers remain after I filter for
another column. Help!
Cisco
|