compare data in sheets and delete the duplicates

R

Ronron2

Hi, Before i stary begging for help thanks for looking at my post an
input / suggestions will be welcome.

On to the problem. I have one workbook with 2 sheets. The first shee
contains multiple columns each hold either numbers or letters neve
both. The second sheet has only one column it contains numbers. What
need to do is take the information on sheet two and compare it it t
the column on sheet one for duplicate entrys. When duplicate are foun
on sheet one's column i need it to delete the row that the dupe wa
found on.

So far i have tried the information posted concerning filters however
no luck either it jumbles the data (probally me doing it wrong) or
recieve error message that only filtered data can be copied.

Anyways sorry to bug you with this but i am at my wits end.

Thanks
Ro
 
J

jackrosiemaisie

I use an Excel add-in called dedupe4excel from DQ Global. It is a goo
routine for identifying and eliminating duplicates. I use it all th
time and find it invaluable. It is not cheap however, but you ca
download a trial version fro
http://www.dqglobal.com/dedupe4excel.htm.

Hope that is useful
 
Top