| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel, How do I get AutoFilter to provide# of records found?
I use Autofilter command a lot and many times it shows the total number of
filtered records from the total anount of records in the lower-left hand part of screen. For instance - it will sat "33 of 90 records found". Inevitably, this stops working and this area just sates "Filter Mode" without the previous info. I have been unable to find any rhyme or reason what I did to stop the valubale info of how many records were found. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Excel, How do I get AutoFilter to provide# of records found?
See Debra Dalgleish's site for info on this.
http://www.contextures.on.ca/xlautofilter02.html#Count Gord Dibben MS Excel MVP On Thu, 19 Jun 2008 07:28:01 -0700, DougD wrote: I use Autofilter command a lot and many times it shows the total number of filtered records from the total anount of records in the lower-left hand part of screen. For instance - it will sat "33 of 90 records found". Inevitably, this stops working and this area just sates "Filter Mode" without the previous info. I have been unable to find any rhyme or reason what I did to stop the valubale info of how many records were found. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change left bottom note that tell number records found? | New Users to Excel | |||
| how do I display filtered records found | Excel Discussion (Misc queries) | |||
| Advanced Filter: Number of Records Found | Excel Discussion (Misc queries) | |||
| Autofilter number of records | Excel Worksheet Functions | |||
| how to display the count of lines found by autofilter? | Excel Discussion (Misc queries) | |||
Hybrid Mode
