| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
# of Records Shown During Auto-Filter Selection
When an auto-filter is turned on, why is it that sometimes the Status Bar (at
the bottom-left portion of the screen) shows the filtered number of records against the total number of filtered records (i.e.: 50 of 150 records found) while other times it does not? This is extremely frustating. What can I do to guarantee that this extremely valuable auto-filter feature works 100% of the time? Thanks, Rick |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
# of Records Shown During Auto-Filter Selection
Debra Dalgleish explains it and gives a workaround:
http://contextures.com/xlautofilter02.html#Count Rick Gomes wrote: When an auto-filter is turned on, why is it that sometimes the Status Bar (at the bottom-left portion of the screen) shows the filtered number of records against the total number of filtered records (i.e.: 50 of 150 records found) while other times it does not? This is extremely frustating. What can I do to guarantee that this extremely valuable auto-filter feature works 100% of the time? Thanks, Rick -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Customizing Auto Filter | Excel Discussion (Misc queries) | |||
| Using Excel's Auto Filter, how can I show # of records returned? | Excel Worksheet Functions | |||
| auto filter question | Excel Worksheet Functions | |||
| The Auto Filter button lost the column specified option. | Excel Worksheet Functions | |||
| Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions | |||
Linear Mode
