| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
Try...
=SUM(IF(FREQUENCY(IF(SUBTOTAL(3,OFFSET(Range,ROW(R ange)-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! In article , deb wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| How Do I Automatically Refresh Auto Filtered Data? | Excel Discussion (Misc queries) | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| random numbers from a data of numbers? | Excel Worksheet Functions | |||
| Counting unique values + frequency | Excel Worksheet Functions | |||
Linear Mode
