hI There,
Please can someone help here... I have data on 1 spreadsheet that indicates a person's performance as a score, and their potential as a score. On a seperate sheet, I have a plotted table, with values on the X axis escalating from 0.0 to 4 in 0.1 intervals, and on the Y axis from 0 to 3 in 0.1 intervals. This is not a graph, but a colour-coded table, with each X and Y reference value having a cell in the table. The data on the source sheet is rounded to 1 decimal place so that it will correspond to the table in the destination sheet.
What I want to do is place the people's names into the cells which correspond with their scores. The problem is that it is dependant on 2 variables, and there will be multiple people with the exact same combination of scores, and I want all of the names to appear in the same corresponding cell.
Is this at all possible?
Please can someone help here... I have data on 1 spreadsheet that indicates a person's performance as a score, and their potential as a score. On a seperate sheet, I have a plotted table, with values on the X axis escalating from 0.0 to 4 in 0.1 intervals, and on the Y axis from 0 to 3 in 0.1 intervals. This is not a graph, but a colour-coded table, with each X and Y reference value having a cell in the table. The data on the source sheet is rounded to 1 decimal place so that it will correspond to the table in the destination sheet.
What I want to do is place the people's names into the cells which correspond with their scores. The problem is that it is dependant on 2 variables, and there will be multiple people with the exact same combination of scores, and I want all of the names to appear in the same corresponding cell.
Is this at all possible?