View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Buffyslay Buffyslay is offline
external usenet poster
 
Posts: 40
Default Compare Rows - any unique into new sheet / delete duplicates

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?