View Single Post
  #1   Report Post  
deb
 
Posts: n/a
Default counting unique numbers in filtered data

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?