Hi all,
I searched the forum, but I had trouble finding the answer.
I have a database (example attached), and I need to contact over 1,000 people.
The problem...
I want to contact people about their missing items.
An individual with 3 missing items will have 3 letters created, instead of 1.
How do I create a mail merge that accounts for duplicate IDs; so that the mail merge will create 1 letter with the missing items, instead of 3?
Excel Help.xlsx
Maybe by extracting missing items in the columns for each person
In I2 array formula and pull formula to the right until you see blanks
=IF($A2=$A1,"",IFERROR(INDEX($F:$F,SMALL(IF($A$2:$A$10=$A2,ROW($A$2:$A$10)),COLUMNS($I$2:I2))),""))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Row\Col Name Address City State Zip Missing Items Missing Items Steve Z 1 nowhere lane nowhere city nw Money Money Ducks Quack Steve Z 1 nowhere lane nowhere city nw Ducks Steve Z 1 nowhere lane nowhere city nw Quack Bill W 2 nowhere lane nowhere city nw Ducks Ducks Alex Q 3 nowhere lane nowhere city nw Money Money Ducks Cows Moo Alex Q 3 nowhere lane nowhere city nw Ducks Alex Q 3 nowhere lane nowhere city nw Cows Alex Q 3 nowhere lane nowhere city nw Moo Tom P 4 nowhere lane nowhere city nw Moo Moo
Last edited by AlKey; 10-14-2014 at 10:31 AM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
HI, One way select True during mergeging process in winword refer the attachment
☚ Click ★ just below left if it helps, Boo?ath?
Thank you for the feedback!
Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools -> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks