Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter doesn't show record count
As I recall, Filter used to show a count of records at the bottom of the
screen after applying a new filter value. But now it doesn't - all I see is the legend "Filter mode". How can I see the record count? I'm using Excel 2003. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter doesn't show record count
Over to the Right side of the screen same level as "filter mode" you'll see
light shaded blocks......right mouse click and select "count" vs Sum....etc. But then you'll have to highlight what you want to count after it is filtered...hope this helps Peter "Eric_NY" wrote: As I recall, Filter used to show a count of records at the bottom of the screen after applying a new filter value. But now it doesn't - all I see is the legend "Filter mode". How can I see the record count? I'm using Excel 2003. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter doesn't show record count
Thanks. I never knew about that feature.
But what happened to the record count on the left side at that same screen level? I'm pretty sure I recall that it used to, or that it sometimes, displays record count without being asked. "rrcd124" wrote: Over to the Right side of the screen same level as "filter mode" you'll see light shaded blocks......right mouse click and select "count" vs Sum....etc. But then you'll have to highlight what you want to count after it is filtered...hope this helps Peter "Eric_NY" wrote: As I recall, Filter used to show a count of records at the bottom of the screen after applying a new filter value. But now it doesn't - all I see is the legend "Filter mode". How can I see the record count? I'm using Excel 2003. Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter doesn't show record count
You are correct, sometimes its there, sometimes not. It's a known error w/ XL.
Alternatively, you could use a header cell somewhere with a subtotal function like =SUBTOTAL(3,A2:A65000) Note that you should make it check a column that always contains data. Subtotal doesn't count filtered rows, so could return the same thing as the record count without you having to select cells. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Eric_NY" wrote: Thanks. I never knew about that feature. But what happened to the record count on the left side at that same screen level? I'm pretty sure I recall that it used to, or that it sometimes, displays record count without being asked. "rrcd124" wrote: Over to the Right side of the screen same level as "filter mode" you'll see light shaded blocks......right mouse click and select "count" vs Sum....etc. But then you'll have to highlight what you want to count after it is filtered...hope this helps Peter "Eric_NY" wrote: As I recall, Filter used to show a count of records at the bottom of the screen after applying a new filter value. But now it doesn't - all I see is the legend "Filter mode". How can I see the record count? I'm using Excel 2003. Thanks. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter doesn't show record count
Thanks.
Some of these Microsoft bugs or deficiencies seem to stay around for quite a long time without being fixed. Do they ever get fixed, I wonder??? Or maybe it's just been too long since I've upgraded. (I'm not looking forward to the upgrade to Office 2007, with its redesigned menus and ribbons, where I'll have to relearn where every feature is.) "Luke M" wrote: You are correct, sometimes its there, sometimes not. It's a known error w/ XL. Alternatively, you could use a header cell somewhere with a subtotal function like =SUBTOTAL(3,A2:A65000) Note that you should make it check a column that always contains data. Subtotal doesn't count filtered rows, so could return the same thing as the record count without you having to select cells. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Eric_NY" wrote: Thanks. I never knew about that feature. But what happened to the record count on the left side at that same screen level? I'm pretty sure I recall that it used to, or that it sometimes, displays record count without being asked. "rrcd124" wrote: Over to the Right side of the screen same level as "filter mode" you'll see light shaded blocks......right mouse click and select "count" vs Sum....etc. But then you'll have to highlight what you want to count after it is filtered...hope this helps Peter "Eric_NY" wrote: As I recall, Filter used to show a count of records at the bottom of the screen after applying a new filter value. But now it doesn't - all I see is the legend "Filter mode". How can I see the record count? I'm using Excel 2003. Thanks. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter doesn't show record count
When your list has many formulas, or if you change a record, the Status
Bar may show "Filter Mode" instead of a count of the visible records. As Peter said, you can use the Subtotal function to count the visible rows. The following MSKB article has some information: The AutoFilter status bar displays the "Filter Mode" message in Excel http://support.microsoft.com/default.aspx?id=213886 And a couple of workarounds described he http://www.contextures.com/xlautofilter02.html#Count Eric_NY wrote: Thanks. I never knew about that feature. But what happened to the record count on the left side at that same screen level? I'm pretty sure I recall that it used to, or that it sometimes, displays record count without being asked. "rrcd124" wrote: Over to the Right side of the screen same level as "filter mode" you'll see light shaded blocks......right mouse click and select "count" vs Sum....etc. But then you'll have to highlight what you want to count after it is filtered...hope this helps Peter "Eric_NY" wrote: As I recall, Filter used to show a count of records at the bottom of the screen after applying a new filter value. But now it doesn't - all I see is the legend "Filter mode". How can I see the record count? I'm using Excel 2003. Thanks. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter every 25th record | Excel Worksheet Functions | |||
How do I get the filter mode to show the good row count? | Excel Worksheet Functions | |||
How to make the record count always show when using filters... | Excel Discussion (Misc queries) | |||
Record count in filter mode | Excel Discussion (Misc queries) | |||
Why does my advance filter only show one record? | Excel Discussion (Misc queries) |