Data comparison for duplication

  
  
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Worksheet Functions RSS
Next:  how do I copy & paste a protected document wi..  
Author Message
Donna
External


Since: Mar 31, 2006
Posts: 94
PostPosted: Fri Jun 12, 2009 10:40 am    Post subject: Data comparison for duplication
Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
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?
Back to top
Shane Devenshire
External


Since: Jan 07, 2009
Posts: 257
PostPosted: Fri Jun 12, 2009 10:57 am    Post subject: RE: Data comparison for duplication [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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?
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Worksheet Functions All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum