Jan 24 2019 08:17 PM - edited Jan 24 2019 08:21 PM
Hi All
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?
Jan 25 2019 03:53 AM