If I have a list of cells that are based on a control form that result in a true or false outcome. And I want to list only those items that are true in a sentence. Example
Example of table
Stoke True
Cancer True
Smoker False
Example of desired outcome:
John has a medical history of: Stoke, Cancer.
I can use the concantante function, but it put's "," in between all cells even if they are false.
Last edited by Teresa; 10-07-2011 at 10:33 AM.
see attatchment
is it help?
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
Thanks that helped with a few tweeks. I have modified the formula you sent me to:
=IF(ISNUMBER(SEARCH("True",C29)),SUBSTITUTE(D29,D29,"High Blood Pressure, "),"")
Because C29 is where the TRUE/FALSE is located and the cell next to it D29 is where the "High Blood Presure" is located. I was unable to figure out how to put D29 + "," as the replace with text. The other thing is how do a have it put a "." on the last of the string, because it may not always be the last cell, it is determined by the last True statement.
C29:C35 D29:D35
Client Condition
FALSE Stroke
TRUE High Blood Pressure
FALSE Alzheimers
FALSE Cancer
FALSE Heart Problems
FALSE Dementia
TRUE Smoker
upload a sample workbook with sample data and your desired results
In order to attach a file Click the Go Advanced button, and click on the Manage Attachments button
I have attached a sample. There are 2 tabs. One is the input screen and the second is the programming tab that all the statements are held. Sorry I am new to this forum, I attached the file to the original post. Thanks for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks