Compare Master Account List with Partner Accounts

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

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

Mike F
"Martin" <[email protected]> wrote in message
news:[email protected]...
> 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