Check out Chip Pearson's site about comparing lists:
http://www.cpearson.com/excel/duplicat.htm

Mike F
"Martin" wrote in message
...
Compare two Excel list: Master List and Partner List.

1. Find Duplicate Account Names
2. After finding all Duplicate Account Names, look for any account with a
blank in the channel partner field.
3. Generate New Combined Account List which ONLY has those accounts which
are duplicates, but have a blank in the channel partner field.

--
Martin