View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Francisco Rodriguez[_2_] Francisco Rodriguez[_2_] is offline
external usenet poster
 
Posts: 9
Default 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