Hi
I am just trying to do a 'negative Hlookup' with some data i have.
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
Damian
I am just trying to do a 'negative Hlookup' with some data i have.
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
Damian