I have a worksheet which has lists of test results, the sheet has been
generated automatically. Unfortunately the way the sheet is layed out is not
particularly useful!
A student may have sat more than one test in different subjects. Each of
these results is on a separate row. e.g. (this is a simplified version -
there are hundreds of names many of which are repeated under different
subject test results)
John Smith Maths D
Jane Brown English C
John Smith English C
Jane Brown Science B
What I would like to do is to transfer the grades to another sheet in the
workbook so it looks like this;
Name Maths English Science
John Smith D C
Jane Brown C B.
So in each of the cells showing the grades I would like a formula that would
search the other sheet, looking for name and subject and the result of the
formula would find the grade! Can I find anything that will do this? - not so
far so hence I'm letting all you experts out there to have a go!
I have found one formula in the forum which involves using match functions
nested within an index formula. I tried to adapt it to my needs but either it
didn't work or I did it wrong (which is probably more likely). Any help or
ideas will be greatly appreciated.