Tavasan65
asked on
Choices will be enter in a single cell
Hello Experts,
What I have is a spreadsheet where there are multiple choices and based on selections of those choices each choice will be shown in a single cell.
I hope the sample is easy to understand. Test-Choice.xlsx
What I have is a spreadsheet where there are multiple choices and based on selections of those choices each choice will be shown in a single cell.
I hope the sample is easy to understand. Test-Choice.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Wish I could delete my posts! I didn't read the comment in the spreadsheet until too late.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're right, barryhoudini. The comment in the workbook confirms that
(** Idea is based on selection on column C thru R will show in column B)
(** Idea is based on selection on column C thru R will show in column B)
ASKER
Thanks so much and the second solution is the best but the computer is locked by IT and will not allow the download. That is why I gave both solutions credit.
=IF(ISERR(FIND(C$2,$B4)),"