| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count the number of records autofilter is showing in Exce
I want to have a count of the number of records that autofilter selects. That
number showed at the bottom of the screen when I first began using Excel (not sure what version; before 2000 anyway), but now, it seems to have disappeared. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count the number of records autofilter is showing in Exce
look in the help index for SUBTOTAL
-- Don Guillett Microsoft MVP Excel SalesAid Software "Patricia O''Donnell SSJ" wrote in message ... I want to have a count of the number of records that autofilter selects. That number showed at the bottom of the screen when I first began using Excel (not sure what version; before 2000 anyway), but now, it seems to have disappeared. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count the number of records autofilter is showing in Exce
=SUBTOTAL(2,A1:A100)
-- Gary''s Student - gsnu200908 "Patricia O''Donnell SSJ" wrote: I want to have a count of the number of records that autofilter selects. That number showed at the bottom of the screen when I first began using Excel (not sure what version; before 2000 anyway), but now, it seems to have disappeared. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count the number of records autofilter is showing in Exce
See this:
http://contextures.com/xlautofilter02.html#Count -- Biff Microsoft Excel MVP "Patricia O''Donnell SSJ" wrote in message ... I want to have a count of the number of records that autofilter selects. That number showed at the bottom of the screen when I first began using Excel (not sure what version; before 2000 anyway), but now, it seems to have disappeared. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unique Records Count with AutoFilter | Excel Worksheet Functions | |||
| How to obtain the number of filtered records in Autofilter | Excel Worksheet Functions | |||
| Count the number of unique records | Excel Worksheet Functions | |||
| Autofilter number of records | Excel Worksheet Functions | |||
| Autofilter - display column showing visible row count | Excel Discussion (Misc queries) | |||
Linear Mode
