Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I want to have a formula in a cell, return the number of visible records
after I apply an AutoFilter. In other words, I want to return the same value that I see in the Status bar after I apply the auto filter. There are multiple columns in the data table. The AutoFilter will be performed on different combinations of columns. Data cells contain blanks, Text and numbers. I am assuming the solution would be to apply a function or custom function to one of the columns and have it count all visible cells, including blanks and cells containing text or numbers. I can't find a function to do this. SubTotal(3,Range) doesn't count blanks which would occur if I AutoFiltered on a different column than the column that is being counted. COUNTBLANK includes invisible cells in the count. In a nutshell, I need a function or custom function to count all visible cells in a column: blank, numeric or text. or Count the number of AutoFiltered records. Same result Thanks for any help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I count the number of records within a date range | New Users to Excel | |||
How do I count the number of records within a date range? New issu | Excel Worksheet Functions | |||
Count Unique Records | Excel Worksheet Functions | |||
Count Records Between A-K and L-Z | Excel Worksheet Functions | |||
Count the number of unique records | Excel Worksheet Functions |