Finding the location of MAX value in column
Hi Milly
Try
=ADDRESS(MATCH(MAX(A:A),A:A,0),COLUMN(A1))
would return $A$10 for example
If you copy across, then A:A would change to B:B and COLUMN(B1) and so
on.
In other words, you need to alter both parameters depending upon which
column you are searching.
Add a ,4 at the end if you wish to change the formula from Absolute to
relative
=ADDRESS(MATCH(MAX(A:A),A:A,0),COLUMN(A1),4)
--
Regards
Roger Govier
"milly" wrote in message
...
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
|