Brain not working well this morning - you also indicated you wanted to delete
the entries with UNIQUE entries. My solution using helper column and filter
works for that also. Just filter to show entries in the helper column with 0
in them and then select them all and delete them. Then unfilter and only the
duplicated entries will remain.

"WYMMIY" wrote:

All

I have a very large list of data and on a monthly basis i need to
display only the duplicate items in a spreadsheet. I would like to do
this in VBA and then run it as a macro on the spreadsheet. Alot of
the sites that i have seen only show how to removed the duplicates.
Excel 2007 has a function which removed all duplicates but so far i
have found nothing that only displays the duplciates.... any ideas
anyone?