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?
|