counting unique numbers in filtered data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I'm trying to use the formula =SUM(N(FREQUENCY(RANGE,RANGE)>0)) to count
unique numbers which in the past has worked great, but now I'm using a
worksheet that is filtered and it's not working. Any suggestions?
 
Try...

=SUM(IF(FREQUENCY(IF(SUBTOTAL(3,OFFSET(Range,ROW(Range)-MIN(ROW(Range)),,
1)),Range),IF(SUBTOTAL(3,OFFSET(Range,ROW(Range)-MIN(ROW(Range)),,1)),Ran
ge))>0,1))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count unique values with auto-filter on 6
Count Unique Values but not Filtered or Hidden Values 3
Filtering Duplicate Data to obtain Unique record 8
count unique elements 4
Count Unique Occurences 4
need help on either doing a loop and counting specific values orusing subtotal function 2
use a function for filtered data 6
count unique values in a filtered range 2

Back
Top