E
ElsiePOA
I have a table in Cells A1:M11. Cells B1:M1 contain Jan thru Dec.
Cells A2:A11 contain team numbers 1 thru 10. The table is populated by
scores. (one score for each team for each month.
What I want to do elswhere on the sheet in three seperate cells) is
show the Maximum score, the Team name and the Month the Maximum score
was achieved.
The max score is no problem. For team name and month, I will use
VLOOKUP formulae refering to two seperate charts. But to use the
VLOOKUP formulas, I need to ascertain the Row() and Column() for the
Maximum score.
I'd like to be able to do this without creating a bunch of helper cells
but don't know how. If I try to use the expression "=ROW(MAX(A1:M11))"
in a VLOOKUP formula I get a message saying there is a mistake in the
formula.
Does anyone know a way to get what I want without creating intermediate
"helper cells"?
Cells A2:A11 contain team numbers 1 thru 10. The table is populated by
scores. (one score for each team for each month.
What I want to do elswhere on the sheet in three seperate cells) is
show the Maximum score, the Team name and the Month the Maximum score
was achieved.
The max score is no problem. For team name and month, I will use
VLOOKUP formulae refering to two seperate charts. But to use the
VLOOKUP formulas, I need to ascertain the Row() and Column() for the
Maximum score.
I'd like to be able to do this without creating a bunch of helper cells
but don't know how. If I try to use the expression "=ROW(MAX(A1:M11))"
in a VLOOKUP formula I get a message saying there is a mistake in the
formula.
Does anyone know a way to get what I want without creating intermediate
"helper cells"?