I have a WorkBook with 5400 Names, Addresses, and various other info.
There are duplicate addresses
I have a column with header "Status"
This Column 'B' has four cell values of Expired, Withdrawn, Active, or Active Contingent
I need to do a Mail Merge and don't want to have duplicates.
I do not need to mail to addresses with Rows that have Status as 'Active' or 'Active Contingent' these ones I cut from Sheet 1 and pasted into sheet 2.
There are duplicate addresses where the same address is listed as both active, expired, and withdrawn, or any combination of the three.
Addresses are in Coumn I on both sheets
Now I need a way to merge Column I on both sheet 1 and 2 and have Excel transfer data to sheet three.
Sheet three would only have Expired or Withdrawal Listings (Column B) and no duplicates of any addresses as well as no 'Active' status'
I hope this makes sense it really is not that complicated I am just missing it.
2007-08-14
20:27:06
·
2 answers
·
asked by
James B
2
in
Programming & Design