Let's try this again. I posted this earlier, but somehow my reply never
appeared to the original even though a successful confirmation appeared....
So, we'll give it another try.
I have a question and answer database that I am maintaining. Each question
has an ID number. Additionally, each answer for the question has other
relevant questions linked to that answer. What I want to do is to create a
column in this database that will tell me for each question ID, what other
questions it's linked to, so when it comes time to change a question or
answer, I know which questions to go back to for updates. I will have over
500 questions and answers, so a formula like "COUNTIF" probably won't work.
For example, here is a brief overview of the database.
ColumnA ColumnB ColumnC ColumnD ColumnE
1 500 504 501
2 501 503 504
3 502 504 500 501
4 503 502 500 504
5 504 500
Column A = Question ID #
Columns B, C, and D = Question ID's of questions that are related to the
Question ID in column A.
Now, what I want to do is in Column E, return the values or the Question
ID's where the original Question ID in Column A appears. So for instance,
for ID# 500 in A1, I want the end result to be "502, 503, 504" since question
500 is a relevant and linked question to questions 502, 503, and 504.
I could have close to 500 or more original questions, but the linked, or
child questions should be 12 or less for each original or parent question.
All of you guys are much more brilliant than I am. Any ideas on how to come
up with those end results? I'm looking for a formula or a series of
formulas.
Thanks for the help! It's much appreciated.
|
Similar Threads
