Home |
Search |
Today's Posts |
#1
|
|||
|
|||
status bar shows "filter mode"
I'm using excel in office 2003 and find that when I use filter I get "filter
mode" instead of number of records. I do not have any formulas in the list I'm filtering, it's just a simple list |
#2
|
|||
|
|||
Hi
see: http://www.contextures.com/xlautofilter02.html#Count -- Regards Frank Kabel Frankfurt, Germany carrie wrote: I'm using excel in office 2003 and find that when I use filter I get "filter mode" instead of number of records. I do not have any formulas in the list I'm filtering, it's just a simple list |
#3
|
|||
|
|||
This might explain/help:
http://www.contextures.com/xlautofilter02.html#Count tj "carrie" wrote: I'm using excel in office 2003 and find that when I use filter I get "filter mode" instead of number of records. I do not have any formulas in the list I'm filtering, it's just a simple list |
#4
|
|||
|
|||
The Status Bar may show 'Filter Mode' if a cell in the list is
changed, after a filter has been applied. You can use the Subtotal function to count the visible rows. The following MSKB article has information: XL2000: Excel AutoFilter Status Bar Message Shows "Filter Mode" http://support.microsoft.com/default.aspx?id=213886 And there are a couple of workarounds he http://www.contextures.com/xlautofilter02.html#Count carrie wrote: I'm using excel in office 2003 and find that when I use filter I get "filter mode" instead of number of records. I do not have any formulas in the list I'm filtering, it's just a simple list -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo Box goes to edit mode even if design mode is in OFF position | Excel Discussion (Misc queries) | |||
Why does excel not see more than 1000 lines in filter mode? | Excel Discussion (Misc queries) | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
auto filter question | Excel Worksheet Functions | |||
coverting answer from Radian mode to degree mode | Excel Worksheet Functions |