Auto Filter & Display

[lehigh46]

Hi All,

Column J is auto filtered

J15 to J500 contains Item Numbers.
Many are alike

I reserved 10 rows at the top of the sheet for summarizing.

I need a formula for G2 that will display the item number which is
autofiltered.

Thanks for your help

Tom

 

[Peo Sjoblom]

Look at the SUBTOTAL function in help

 

[Debra Dalgleish]

There's a sample file here that uses programming to show the criteria
use in the filter:

http://www.contextures.com/excelfiles.html

Under Filters, look for 'FL0007 - Highlight AutoFilter Headings'

You could adapt that to show the criteria for your Item Numbers column.