Duplicates

  • Thread starter Thread starter wynand
  • Start date Start date
W

wynand

my data is on two different sheets in one workbook (sheet1-A1:A200 and
sheet2- A1:A1096) .
would like to compare the two columns for duplicates and extract to a new
sheet or higlight duplicates in order for further detailed analysis.
 
thank you
have tried "Extracting Elements Common To Two Lists" on the site, but my
columns have different number of rows, so haven't suceeded yet.
 

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

=Sheet!A1 formula alternative 2
Workbook_Open code help 1
Pulling an column/row Data from one sheet- another if critria is m 1
Same Column on Two Sheets (Auto-update / match)? 4
Code to format cells on several worksheets 2
Fill formula down for cells 74 rows apart 3
Duplicates Deletion ? 2
Removing Duplicates to another sheet 1

Back
Top