filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Check out the SUBTOTAL worksheet function in Help.

HTH
Jason
Atlanta, GA
 
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 here:
http://www.contextures.com/xlautofilter02.html#Count
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number of records after filter 2
Count Advanced Filtered Rows 3
Auto Filter in Excel 1
How to remove stuff that appears when I click on the windows button on the bottom left of my screen? 2
Macro to copy value in field and insert it into filter 2
Advanced Filter By Cell Contents 1
How do I get the filter mode to show the good row count? 2
Case Sensitive Counting & Filtering 1

Back
Top