Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
List of cells that were selected
I have a list of 250 names where each name can select one or all of the same
names in the list to send a gift basket. The final output needs to have two key columns: the name of the recipient and the list of names of people that selected the person. I will pass this list to microsoft word in mail merge and create a letter which lists all of the people that selected the person. I created a 5x5 prototype which works but is not a great option for the 250 list. In my prototype I put 'X' in the grid and then did a large concenate function where I concatenated the name from the heading if there was an 'X' in the column. I guess I could do this for all 250 rows but there has to be a better way. Any ideas? example Mary John Bill Ann Mary X X John X Bill Ann X X X In this example, Mary bought a basket for John and Bill. John bought one for Mary and Ann bought one for everyone. In reality everyone is going to get ONE basket so the problem is just creating a letter that lists all of the people that bought a basket for the person. Mary would receive a letter with John and Ann's name, John would get one from Mary and Ann. (You get the picture.) My solution was to create a common separate list of all the names in a single field and then use this in the mail merge of MS word. That isn't going to work that well for 250 names but I guess it could if there is no easier way. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List and subtotal selected items, then print separate item list | Excel Worksheet Functions | |||
Autofill cell/sets of cells based upon value selected from a list. | Excel Discussion (Misc queries) | |||
Cells are selected but aren't displayed as selected | Excel Discussion (Misc queries) | |||
Cells are selected but aren't displayed as selected | Excel Worksheet Functions | |||
A validated List which link to selected cells according to what is selected on the list | Excel Worksheet Functions |