We have an inherited SS which has many autofilters set. Some of them, when activated, display the number of filted lines on the grey bar at the bottom left of the screen and some do not, eg 245 of 27485 records found. How do we set this function?
We have an inherited SS which has many autofilters set. Some of them, when activated, display the number of filted lines on the grey bar at the bottom left of the screen and some do not, eg 245 of 27485 records found. How do we set this function?
The subtotal function can do this. Try =SUBTOTAL(102,A1:A500) (changing the cell range, of course). If you look up help on SUBTOTAL you will see the paramaters that are available.
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks