The commercial Excel add-in XL Companion, from yours truly,
does what you describe. There is a free trial available...
http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
San Francisco, USA


"Buffyslay"
wrote in message
Compare Rows - any unique into new sheet / delete duplicates

OK, I have a worksheet comparing sets of data in one sheet.
Many columns. around 2500 rows

1: I need to compare rows and copy any unique values into a different sheet.
then i need to split these out based on the value in col A (there will only be 2 values)

2. back to original doc, this now needs all the duplicates removing simple?