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