Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Advanced Filter had been telling me the Number of Records Found (in the lower
left of my screen.) Now it has stopped doing that, on the same set of data. Any ideas on what I have changed? Thanks, Charlie Rowe |
#2
![]() |
|||
|
|||
![]()
Do you mean the AutoFilter? If so, 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 Charlie Rowe wrote: Advanced Filter had been telling me the Number of Records Found (in the lower left of my screen.) Now it has stopped doing that, on the same set of data. Any ideas on what I have changed? Thanks, Charlie Rowe -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
![]() |
|||
|
|||
![]()
Thanks. That was it.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Advanced Filter is grayed out | Excel Worksheet Functions | |||
why can't i use the advanced filter on my data | Excel Discussion (Misc queries) | |||
Advanced Filter Not Working | Excel Discussion (Misc queries) | |||
need help with Advanced filter. | Excel Discussion (Misc queries) | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |