| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Unique Values but not Filtered or Hidden Values
Hello,
I'm trying to count unique values in a row and have a filter at the same time. I'm using the formula =SUM(IF(FREQUENCY(I1:I255,I1:I255)0,1)) When I use a filter it doesn't recalculate. I tried to use the subtotal 109 function but i'm appearantly not inserting it correctly. Can anyone help? Thanks, Lee |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count unique values in a filtered range | Excel Worksheet Functions | |||
| Count Unique Values In A Filtered Row with Duplicates | Excel Discussion (Misc queries) | |||
| Count unique values and create list based on these values | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Unique Count sensitive to hidden/filtered rows | Excel Worksheet Functions | |||
Threaded Mode
