Finding the location of MAX value in column
Hi Milly
If you know the column this will do
=ADDRESS(MATCH(MAX(A1:A15),A1:A15),1)
It find the max in column A. If you wanted to find the max in column C then
change the ",1)" in the formula to ",C) and change the range to suit.
Regards
Peter
"milly" wrote:
I know this is a very simple question but I have found the MAX value in a
column using the usual formuls, the only problem is I don't know it's
location and I need to relate back to another value on the same row. The
column contains nearly 3000 readings so I don't fancy trawling through them
all tring to find it!
Can anyone please help asap
Thanks a million
|