Creating a list in one Excel cell by referencing several other cells

55 pts.
Tags:
Concatenate
Microsoft Excel
Microsoft Excel formulas
Using excel and I am trying to make a list generated into one cell, or cells right under each other. I have 85 choices for the user to select. If the user selects a symptom (column b, I want the treatment (in column C) to be displayed on a different tab. So the user would go through tab one and select the various symptoms that someone has, then on the following tab the user could see the symptom with the treatment next to it. All the symptoms not selected would not appear and there would not be many blank cells, but only a list of symptoms the person has and the treatment. I was originally trying to have the user mark an "X" in column A to signify they had the symptom in column b. On the second tab I then used =If(isblank(A#),"",C#) to make all the treatments appear, but then I have the problem of many blank cells in-between each selection. I tried using =concatenate but it just makes all of the treatments run together and cannot be read easily.
ASKED: April 22, 2009  2:46 AM
UPDATED: June 9, 2009  7:59 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Adventurous way to use excel. Apart from the large RAM requirement to run the queery, it would be a pig to administer. So, unless you have a definate reason for doing it this way, I’d use a db in the following way.

I think I would have created an Access db with the symptom in one column and the treatment in another, then after the user indicates that they have entered all the symptoms I’d do a filtered search on each symptom retreiving the treatment, into the adjacent cell.

As an added refinement, I’d do a sort on the treatment column, (that way all the same treatments could be together,) then a copy unique sort could be done to shorten the list of treatments presented to the user.

Just an idea. Good luck.

=============================
See if there might be some ideas on this <a href=”http://www.cpearson.com/excel/mainpage.aspx”>Excel resource website – Pearson Software Consulting</a>. I go here frequently for answers to difficult Excel questions.

In the IT trenches? So am I – read my <a href=”http://itknowledgeexchange.techtarget.com/it-trenches”>IT-Trenches blog</a>

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following