Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto count from autofilter
Dear all,
I used to get a auto count on the left-hand bottom corner, e.g. "75 of 2992 records found" if I pick a item from the drop down list of auto-filter. But sometime this information is not coming out on some excel file. Do I need to do some setting change so that the auto count will alway appear? Thanks a lot! Marisa |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto count from autofilter
If 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 Marisa wrote: Dear all, I used to get a auto count on the left-hand bottom corner, e.g. "75 of 2992 records found" if I pick a item from the drop down list of auto-filter. But sometime this information is not coming out on some excel file. Do I need to do some setting change so that the auto count will alway appear? Thanks a lot! Marisa -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count down with auto fill? | Excel Worksheet Functions | |||
Need formula to count spinoffs | Excel Worksheet Functions | |||
Auto Filter - Protected sheet/workbook | Excel Discussion (Misc queries) | |||
Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
with Autofilter on, display count results in lower left corner wit | Excel Worksheet Functions |