Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number of records after filter
When I filter a list the bottom left corner says 143 of 515 records (or
something along those lines). That is great. However, sometimes it does not give me that it just says "Filter Mode" and I cannot see how many records there are. Anyone know why? I realize that you can do a worksheet function to do this but sometimes it is not practical to do this. Any thoughts? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number of records after filter
Are you using Excel 2003? I do not know for sure but I think if the function on the status line is count then you see it otherwise not. "Jon Dow" wrote: When I filter a list the bottom left corner says 143 of 515 records (or something along those lines). That is great. However, sometimes it does not give me that it just says "Filter Mode" and I cannot see how many records there are. Anyone know why? I realize that you can do a worksheet function to do this but sometimes it is not practical to do this. Any thoughts? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number of records after filter
dHi,
There are a number of reasons for this and they include: 1. A known Excel bug 2. A macro that has placed status bar text in that area but not removed it. 3. Once you enter a formula or change a value in the spreadsheet that would normally cause the spreadsheet to recalculate, the text reverts to Filter Mode 4. there are probably other reasons However, whether COUNT or any of the other options are on in the right hand side of the Status Bar has not effect. You can work around this problem: Suppose your filter is in cell A2, then in A1 or any empty cell you choose enter the formula: =SUBTOTAL(3,A2:A3092) &" of "&COUNTA(A2:A3092)&" records found" -- Thanks, Shane Devenshire "Jon Dow" wrote: When I filter a list the bottom left corner says 143 of 515 records (or something along those lines). That is great. However, sometimes it does not give me that it just says "Filter Mode" and I cannot see how many records there are. Anyone know why? I realize that you can do a worksheet function to do this but sometimes it is not practical to do this. Any thoughts? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter Unique Records | Excel Discussion (Misc queries) | |||
How can I always get subtotals (4 of 12 records)when I filter a sh | Excel Discussion (Misc queries) | |||
Advanced Filter: Number of Records Found | Excel Discussion (Misc queries) | |||
How do I show number of records that meet criteria filter | Excel Discussion (Misc queries) | |||
Why does it say "Filter mode" instead of "X of Y records"? | Excel Worksheet Functions |