Show Cell Reference
Formula correction:
=ADDRESS(MATCH(MAX(D2:D20),D2:D20,0),2)
--
Thanks for the brainwaves!
"CJ" wrote:
Hi, I it is close, but not quite.
I created a column of data starting at 10 incrementing by 5 from D2 - D20
(10 - 100). When I use your suggestion in cell D21, it give me the answer of
$B$19
Here is my formula: =ADDRESS(MATCH(MAX(D2:D21),D2:D21,0),2)
???
--
Thanks for the brainwaves!
"willwonka" wrote:
Maybe this works:
=address(match(max(b1:b250),b1:b250,0),2)
CJ wrote:
Hi Groupies
I would like to be able to see which cell the Max function is referring to.
For example: I have a list of values in B1 - B250. The Max function returns
the highest value in that range, but I would also like to find out which cell
contains that value. Is this possible?
--
Thanks for the brainwaves!
|