I am using an excel spreadsheet that someone else created. There are tons of filters etc.
WHen I filter say by name it narrows the number of records down. When I highlight them the record count is more than what I have selected.
It seems that its just hiding the ones not satisfied by the filter. So I get those in the count as well...
Is there a filter count? Is there a way to highlight the records from a filter and not get the records that are hidden?
For instance I run a filter...I get 65 records, but when I highlight all of them i get 534 records. I understand that I am getting the records inbetween because on the left you can see the row number going from 55 and the next one is 82. If I highlight those 2 rows I get 27 records
I am jsut trying to get a record count on the records that are in the filter....
PLease help....
When you select one of the filters, does it now show you how many records are affected in the status bar (lower left corner of screen)? It should say something like "22 of 214 records found".
No.....Is there a place that I can turn that on???? I am running 2007 and cant seem to find this...
thanks
Oddly enough I don't think you can even hide the status bar in Excel 2007 like you could in previous versions. Do you see any information below the sheet tabs? Like "Ready" or "NumLock" etc? You can right-click on the bar below the sheet tabs and you'll see options of what you can show or hide, but I don't think filtered row counts is one of the options you can toggle.
Assuming row 1 is the Name heading, Name is column B, and there are 534 records
try this
=SUBTOTAL(2,B2:B535)
this will return a count of the number of records displayed after filtering the name column
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks