| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Unique Count sensitive to hidden/filtered rows
Hello.
I need to count unique values in a list. I have many ways to do this (I am currently using an array function {=SUM(IF(COUNTIF(A9:A1000,A9:A1000)=0, 0, 1/COUNTIF(A9:A1000,A9:A1000)))}, and that works fine. But - I wish to be able to filter the list and have the function adjust to only the visible cells. I tried substituting the SUBTOTAL function for SUM in the formula above, but I get an ERROR result. I am willing to use intermediate columns if I must. Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Unique in Pivot Table | Excel Discussion (Misc queries) | |||
| Count Rows with Conditional Format? | Excel Discussion (Misc queries) | |||
| Pivot Table Unique Count | Excel Worksheet Functions | |||
| How do I count or display unique data in a column? | Excel Worksheet Functions | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
