Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How come my filter does not work?
Hi again,
I encountered strange problem with my multi-sheet excel I've been working on. I have a sheet_2 that's full of different matrix-functions which tracks the changes in cells in sheet_1 . What I need to do (for double-checking purposes) daily is to auto-filter 1st row and count the number of particular values on one column. Normally, Excel gives me this nice little number on lower -left corner that sum up the quantities of how many specific values was found. But now when I have this sheet_2 (with all the matrix-functions) - I'm indeed able to go auto-filter mode and do the actual filtering BUT it doesn't give me the number anymore?! After I delete sheet_2 - everything works fine and I'm able to do the effective auto-filtering. I just don't understand what excel does to prevent itself giving me the filter results. If I delete sheet_2 - filtering works normal. Any ideas? Thanks in advance! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How come my filter does not work?
Hi,
The Status Bar display of the Auto Filter results has a number of known issues. As a work around do this, suppose the column you want to count is column A1:A100, before applying the filter. In an empty cell enter the formula: =SUBTOTAL(3,A1:A100) When you filter your data this cell will tell you how many items were found. If this helps, please check the Yes button. -- Thanks, Shane Devenshire "Karpo" wrote: Hi again, I encountered strange problem with my multi-sheet excel I've been working on. I have a sheet_2 that's full of different matrix-functions which tracks the changes in cells in sheet_1 . What I need to do (for double-checking purposes) daily is to auto-filter 1st row and count the number of particular values on one column. Normally, Excel gives me this nice little number on lower -left corner that sum up the quantities of how many specific values was found. But now when I have this sheet_2 (with all the matrix-functions) - I'm indeed able to go auto-filter mode and do the actual filtering BUT it doesn't give me the number anymore?! After I delete sheet_2 - everything works fine and I'm able to do the effective auto-filtering. I just don't understand what excel does to prevent itself giving me the filter results. If I delete sheet_2 - filtering works normal. Any ideas? Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter by Top 10 doesn't work | Excel Worksheet Functions | |||
Why doesnt my filter work!!!!! | Excel Discussion (Misc queries) | |||
filter count does not work | Excel Discussion (Misc queries) | |||
Filter does not work | Excel Discussion (Misc queries) | |||
Scratch that, using a filter did not work | Excel Discussion (Misc queries) |