Duplicates

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.
 
W

wynand

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
Removing Duplicates to another sheet 1
Highlite Duplicates in 2 Columns (Conditional Formating) 3
Compare identifier columns from 2 sheets - remove rows that are dups 2
Finding Duplicates in Multiple Columns 2
Code to format cells on several worksheets 2

Top