Thread: Compare Master Account List with Partner Accounts
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Martin Martin is offline
external usenet poster
  
Posts: 336
Default 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
Reply With QuoteReply With Quote