ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to display the count of lines found by autofilter? (https://www.excelbanter.com/excel-discussion-misc-queries/20812-how-display-count-lines-found-autofilter.html)

elaineb

how to display the count of lines found by autofilter?
 
Using autofilter to filter rows in a range used to give a count of the number
of rows found in the bottom left hand of the screen. Now I have excel 2003
that very useful feature does not seem to be there. Is this a setting I have
not found? Is there anyway of getting it back?

Dave Peterson

It's still there, and it still disappears every once in a while.

Debra Dalgleish has some workarounds at:
http://www.contextures.com/xlautofilter02.html#Count



elaineb wrote:

Using autofilter to filter rows in a range used to give a count of the number
of rows found in the bottom left hand of the screen. Now I have excel 2003
that very useful feature does not seem to be there. Is this a setting I have
not found? Is there anyway of getting it back?


--

Dave Peterson


All times are GMT +1. The time now is 05:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com