| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filter count does not work
If Tools Option is set to Calculation is set to Auto, the filter count does
not work. -- Message posted via http://www.officekb.com |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filter count does not work
When your list has many formulas, or if a cell in the list is changed
after an AutoFilter has been applied, the Status Bar may show "Filter Mode" instead of a count of the visible records. The following MSKB article has information: The AutoFilter status bar displays the "Filter Mode" message in Excel http://support.microsoft.com/default.aspx?id=213886 And there are a couple of workarounds he http://www.contextures.com/xlautofilter02.html#Count s2m via OfficeKB.com wrote: If Tools Option is set to Calculation is set to Auto, the filter count does not work. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotals by count | Excel Discussion (Misc queries) | |||
| count records which meet filter criteria | Excel Discussion (Misc queries) | |||
| custom filter does not work correctly | Excel Discussion (Misc queries) | |||
| Visible rows and functions that work | Excel Worksheet Functions | |||
| Heelp...the "begin with" custom filter does not work | Excel Discussion (Misc queries) | |||
Hybrid Mode
