| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Choose items from a list and add to a string in a cell
This will work for your sample data:
=IF(Sheet1!C2="Y",Sheet1!A2&", ","")&IF(Sheet1!C3="Y",Sheet1!A3&", ","")&IF(Sheet1!C4="Y",Sheet1!A4&", ","")&IF(Sheet1!C5="Y",Sheet1! A5&", ","")&IF(Sheet1!C6="Y",Sheet1!A6&", ","")&IF(Sheet1! C7="Y",Sheet1!A7&", ","") assuming it is on Sheet1 and occupies A1:C7. Hope this helps. Pete On Jul 21, 7:19*pm, Ben wrote: Hello I have Excel Spreadsheet, with the following columns containing a list of our office with an office code. *':' is the column seperator here Code:Office:Selected? LEI:Leicester:Y NOT:Nottingham:N SHF:Sheffield:N DON:Doncaster:Y MAN:Manchester:N BHM:Birmingham:Y On a seperate sheet, I have a box that I want to populate with a list of office codes, seperated by a comma, which has a 'Y' in the selected column. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search if a string contains text matching items in a list | Excel Worksheet Functions | |||
| How do I choose multiple items from a drop down box? | Excel Worksheet Functions | |||
| can excel choose a name from a list when I am typing in a cell | Excel Worksheet Functions | |||
| choose a particular word in a string | Excel Discussion (Misc queries) | |||
| How do I compare two lists and choose the items that are in both? | Excel Worksheet Functions | |||
Threaded Mode
