Look at the SUBTOTAL function in help

--
Regards,

Peo Sjoblom


"lehigh46" wrote in message
...
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