Data comparison for duplication
 

I have two workbooks. I want to compare names in one workbook to names in
another workbook so that I can delete duplicate names. What would be the
easiest way to do this?

Data comparison for duplication
 

Hi,

Try a formula like:

=IF(COUNTIF(A2,[tempTest.xlsx]Sheet2!$B$1:$B$1000)0,1,"No")

copy this formula down. If the name is in the other workbook you will get a
count of 1.

Highlight these formula results and press F5, Special, Formula, and uncheck
all but the Numbers options, click OK.

Press Ctrl+- (control minus) and choose delete entire row.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Donna" wrote:

I have two workbooks. I want to compare names in one workbook to names in
another workbook so that I can delete duplicate names. What would be the
easiest way to do this?