Forum Discussion
Identify values and then display the content of the cell.
I am trying to set up a questionnaire that self populates the results. I have the answers given to 9 questions of 7 sections in a table (table is 9x7) Seen below:
Each column is then summed, and values can range from 0-70. I then have another 3x3 table that identifies what rank the summed column is, from highest to lowest, and enters the value of that column. For example, if column 1 =70 then this would be the first highest number and entered into the first box of the 9x9 and then this goes down to the lowest. Shown below:
What I don't know what to do, is get excel to enter the column title in to another grid based on the values in the above table, I want to enter them in to the following table:
What I want to do, is once I identify which column has the highest number, is to display the title of that column (which is text) so the column headers are (CO, SH, PL, ME, IMP, TW, RI, CF AND SP). The final part of this is, that each heading is then displayed to the person completing the questionnaire.
I hope this makes sense?
Many thanks in advance
Nick