excel help

68falcon

Senior member
May 8, 2005
274
0
0
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
 

cacu

Junior Member
Jan 17, 2006
5
0
0
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

Senior member
May 8, 2005
274
0
0
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