I have a spreadsheet which takes a students details and subject scores. I then have a column which returns the name of the students highest subject. (See image)
The formula works for the first row. I would however like the formula to also return a value as other rows are added for new students (without having to copy down the formula each time).
I came across the Array formula function but cant seem to find a way to a solution.
Am I missing something or is there an easier way to create this?