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.

lehigh46 wrote:
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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html