Hi

I am just trying to do a 'negative Hlookup' with some data i have.

\1

Using the data above, column F has the largest values from each row.
What i want to do is, use this largest value, look it up in the row and return the column name.(eg. maths or english.) how can i avoid the problem of having duplicate numbers also ?

is this possible ?

thanks