Returning Column Title based on cell value

**paulstuartbullock** · 06-29-2015, 06:08 PM

Hi, I'm working on a student tracking sheet where students have various grades in different subjects. I'm using 'LARGE' to identify their best grades within a selection of subjects, but I need a way of pulling the column reference to accompany a given cell and locate this in the adjacent cell.

That is, if a student has five grades say in Maths (7), English (5), French (4), Geography (9) and History (8), and I wish to identify not only the top 3 grades, but also the subjects of those grades and have them reported elsewhere: 9, Geography, 8 History, 7 Maths. Can anyone point me in the right direction. I can find a hundred ways of returning the column letter, but not the reference I've created.

**FDibbins** · 06-29-2015, 06:24 PM

You could probably use INDEX/MATCH for that, but I suggest that you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

**paulstuartbullock** · 07-06-2015, 06:34 PM

Thank you, that alone has helped hugely. However, I am in the position where I need to take the first three scores and corresponding subjects from one grouping, and the first three from another grouping (Which includes 4th onwards in the first group).

I ultimately need these six scores, plus the corresponding subjects to be output somewhere.

The example uploaded has several subjects with an equal score (Perfectly likely), but my formulae only pick up the first value they find and output this twice when this happens, as you can see (Z8 and AB8 are both showing Geography, similarly BE8 and BG8). Also a little unsure if my use of LARGE 4/5/6/7 is the best solution to identify the lower scores in the first group.