G
Guest
Hi--
I have a range of cells J8:T8. The following formula returns the address of
the cell with the highest value in that range:
=ADDRESS(8,9+MATCH(MAX(J8:T8),J8:T8,0),4)
Does anyone know how I might modify this so that it returns only the column
number in the address? If, for example, the highest value is in cell R8, I
need the formula to return only "R".
I know this sounds stupid, but if anyone can assist, I'd be very appreciative!
Michael Link
Hapless low-level corporate functionary
I have a range of cells J8:T8. The following formula returns the address of
the cell with the highest value in that range:
=ADDRESS(8,9+MATCH(MAX(J8:T8),J8:T8,0),4)
Does anyone know how I might modify this so that it returns only the column
number in the address? If, for example, the highest value is in cell R8, I
need the formula to return only "R".
I know this sounds stupid, but if anyone can assist, I'd be very appreciative!
Michael Link
Hapless low-level corporate functionary