MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Autofilter


Posted by Michael on July 23, 2001 6:38 PM

I have a list that is being filtered. I need to display the value that the filter is using and after the list is filtered on the bottom bar it shows how many records match, I need that value to be displayed in the spreadsheet also?


Posted by Mark W. on July 25, 2001 8:25 AM

Use SUBTOTAL().