Forum Discussion
Return multiple values across multiple sheets
I have multiple sheets in a workbook for teachers to record marks in tests students take. Students will progress through these tests at different rates and I want a summary of what test students are ...
Thank you so much for your assistance, the record that i want reported is the highest subtest level i.e. The highest number subtest for Carly Simon would be Subtest 5, the date achieved and the result. I can see in my dummy data that she achieved a result in 3 after 5- my error with the dummy data.
