excel help

[68falcon]

i have two excel sheets with about 400 names each(along with other categories) is there anyway i can merge the two by first and last name and have it cancel out the duplicates

 

[68falcon]

bump

 

[Sophia]

My Excel skills are feeble, but this excel reference website has helped me at least find duplicates in a document, so I wouldn't be surprised if they have the info you are looking for. Perhaps start in the duplicates section.

 

[cacu]

I'm not an Excel pro but if you have some reporting tool like Crystal Reports then you can do a lookup table and it should be pretty easy to do.

 

[68falcon]

anybody with a strong background in excel know how. i used the links and tried googling it but all i can find is how to do one row at a time, i need to do two, first and last name, thanks for the help. can it be done in mail-merge, just anything in office

 

[68falcon]

anyone?