| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to filter and count unique record?
Hi,
I want to have the number of cells when I filter on a unique record. Please let me know how. Regards Farnoosh |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to filter and count unique record?
The SUBTOTAL() functions allows us to do math on filtered data. Something like
=SUBTOTAL(2,A1:A100) SUBTOTAL ignores the "invisible" rows -- Gary''s Student - gsnu200752 "Farnoosh" wrote: Hi, I want to have the number of cells when I filter on a unique record. Please let me know how. Regards Farnoosh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter doesn't show record count | Excel Discussion (Misc queries) | |||
| unique record count with multiple criteria | Excel Worksheet Functions | |||
| Attempting to sort unique/only count first record in each unique g | Excel Discussion (Misc queries) | |||
| Count duplicates as unique record, sum amounts? | Excel Programming | |||
| Record count in filter mode | Excel Discussion (Misc queries) | |||
Linear Mode
