Home |
Search |
Today's Posts |
#1
|
|||
|
|||
filter
HI,
I just applied a filter to my records. How do I find out how many records I now have? In other words, how do I find out how many records matched the criteria? This number did appear at first at the bottom left of my worksheet, but it's no longer there. |
#2
|
|||
|
|||
Check out the SUBTOTAL worksheet function in Help.
HTH Jason Atlanta, GA -----Original Message----- HI, I just applied a filter to my records. How do I find out how many records I now have? In other words, how do I find out how many records matched the criteria? This number did appear at first at the bottom left of my worksheet, but it's no longer there. . |
#3
|
|||
|
|||
If your list has many formulas, the Status Bar might show "Filter Mode"
instead of a count of the visible records. You can use the Subtotal function to count the visible rows. The Status Bar may also show 'Filter Mode' if a cell in the list is changed, after a filter has been applied. 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 andrea wrote: HI, I just applied a filter to my records. How do I find out how many records I now have? In other words, how do I find out how many records matched the criteria? This number did appear at first at the bottom left of my worksheet, but it's no longer there. -- 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 | |||
Advanced Filter: No Filter | 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 | |||
The Auto Filter button lost the column specified option. | Excel Worksheet Functions | |||
Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions |