ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Filter results returning a count __ of __ (https://www.excelbanter.com/excel-discussion-misc-queries/205549-filter-results-returning-count-__-__.html)

caryn

Filter results returning a count __ of __
 
I remember there being a result in the bottom left hand corner of the Excel
Window when using the Auto Filter feature in Office 2000. This would return a
## of ## when you filtered on an item in a database.

Now the only thing I am seeing is "Filter Mode" in the bottom left-hand
corner.

Any thoughts/solutions to this?
--
Caryn

Dave Peterson

Filter results returning a count __ of __
 
Debra Dalgleish explains the problem and offers a couple of work arounds:
http://contextures.com/xlautofilter02.html#Count

caryn wrote:

I remember there being a result in the bottom left hand corner of the Excel
Window when using the Auto Filter feature in Office 2000. This would return a
## of ## when you filtered on an item in a database.

Now the only thing I am seeing is "Filter Mode" in the bottom left-hand
corner.

Any thoughts/solutions to this?
--
Caryn


--

Dave Peterson


All times are GMT +1. The time now is 07:34 AM.

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