| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
User choice listed in cell.
I have a user fill in (2) out of (6) cells with numbers. I would like their
choice in a cell. In this case as "B, D". I can't come up with a formula Input A A Input B 150 B Input C C Input D 4.5 D Input E E Input F F B, D Thanks in advance, Elzard. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
User choice listed in cell.
Assume the posted table is within A1:C6
Put in D1, copied down to D6: =IF(B1="","",C1) Then placed in say, C7: =SUBSTITUTE(TRIM(D1&" "&D2&" "&D3&" "&D4&" "&D5&" "&D6)," ",", ") will return the required results, eg: B, D (for the scenario posted) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Elzard" wrote: I have a user fill in (2) out of (6) cells with numbers. I would like their choice in a cell. In this case as "B, D". I can't come up with a formula Input A A Input B 150 B Input C C Input D 4.5 D Input E E Input F F B, D Thanks in advance, Elzard. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
User choice listed in cell.
Thanks for your help Max. That works perfect.
"Max" wrote: Assume the posted table is within A1:C6 Put in D1, copied down to D6: =IF(B1="","",C1) Then placed in say, C7: =SUBSTITUTE(TRIM(D1&" "&D2&" "&D3&" "&D4&" "&D5&" "&D6)," ",", ") will return the required results, eg: B, D (for the scenario posted) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Elzard" wrote: I have a user fill in (2) out of (6) cells with numbers. I would like their choice in a cell. In this case as "B, D". I can't come up with a formula Input A A Input B 150 B Input C C Input D 4.5 D Input E E Input F F B, D Thanks in advance, Elzard. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
User choice listed in cell.
Welcome, glad it helped.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Elzard" wrote in message ... Thanks for your help Max. That works perfect. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to link dropdown box choice to another cell | Excel Discussion (Misc queries) | |||
| Drop down choice sends text to another cell | Excel Discussion (Misc queries) | |||
| Start Macro after user selects a choice from a pick list | Excel Discussion (Misc queries) | |||
| How do I set up a drop down choice in a cell | Excel Discussion (Misc queries) | |||
| limit choice in cell to one of two values; | Excel Discussion (Misc queries) | |||
Linear Mode
