Use datafilterautofilterfilter by column desired

--
Don Guillett
SalesAid Software

"EaglesNest" wrote in message
...
Hi All,

I have seen the question with that same title however that is not exactly
"showing" duplicates. It is more showing unique (not duplicate) I would
like to truly show the duplicates.

For instance there are several duplicate product numbers that are in my
sheet and I want to display all the duplicates so that I can make
corrections.

IE:
Item number
31323
31324
31325
31326
31326
31327
31328
31328
31329
31330
31331

How can I filter so that excel will only show those rows that have
duplicate
Item numbers?

Thanks
Eagle