Compare Rows - any unique into new sheet / delete duplicates

B

Buffyslay

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?
 
J

Jim Cone

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" <[email protected]>
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel for comparing two columns exceeding 1,048,576 count 3
Delete duplicate rows without deleting entire row 1
Help! Can’t debug macro used to delete duplicate rows 2
Finding new records in subsequent reports (XL07) 0
Advanced compare of two worksheets 2
Compare two spreadsheets and eliminate duplicates 7
Macro for comparing columns and highlighting matching/differences 13
combining data from 2 sheet into new sheet based on like values 2

Top