Selecting duplicate rows that are present in separate wroksheets

  • Thread starter shawnews.vc.shawcable.net
  • Start date
S

shawnews.vc.shawcable.net

Hello!
I have two worksheets with contact data entered in rows. There are roughly
300 rows in Worksheet A which are also present in Worksheet B. I wish to
compare the worksheets for the purpose of eliminating the rows present in
both worksheets.

Any ideas out there?

James West
 
D

Dnereb

Consider using a database instead of a spreadsheet for data storage
in a database this would be very easy to d
 
I

ilanr01

shawnews.vc.shawcable.net said:
Hello!
I have two worksheets with contact data entered in rows. There ar
roughly
300 rows in Worksheet A which are also present in Worksheet B. I wis
to
compare the worksheets for the purpose of eliminating the rows presen
in
both worksheets.

Any ideas out there?

James West
Click to expand...

I am not sure what you need, but if you want one sheet with uniqu
records, you can copy both worksheets into a new one, then filter wit
"unique records only" checked and copy the results to a new sheet.
Ila
 
Top