Data comparison for duplication

[Donna]

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?

 

[Shane Devenshire]

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.