ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   AUTOFILTER-Totals on the left down corner marge do not appear (https://www.excelbanter.com/excel-worksheet-functions/39164-autofilter-totals-left-down-corner-marge-do-not-appear.html)

Peter Wouters via OfficeKB.com

AUTOFILTER-Totals on the left down corner marge do not appear
 
When using autofilter, I do become a result of this filtering (count of
records found on total amount of existing records) normally. There are some
of my other workbook sheets that do NOT give any result down left under, just
mentioning auto filter in the marge... Why do some sheet give a result and
others do not give anything ? Can one influence the behaviour of excell in
any way to always have such (subtotal / total) display in the lower left
margin, when autofiltering ?
Who knows the solution ?

--
Peter Wouters from Antwerp Belgium

Ron de Bruin

See
http://www.contextures.com/xlautofilter02.html#Count

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Peter Wouters via OfficeKB.com" wrote in message ...
When using autofilter, I do become a result of this filtering (count of
records found on total amount of existing records) normally. There are some
of my other workbook sheets that do NOT give any result down left under, just
mentioning auto filter in the marge... Why do some sheet give a result and
others do not give anything ? Can one influence the behaviour of excell in
any way to always have such (subtotal / total) display in the lower left
margin, when autofiltering ?
Who knows the solution ?

--
Peter Wouters from Antwerp Belgium





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

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