A
aduroche
Hello,
I have a range on which I am looking for the max value:
E51=MAX($B$54:$L$54)
Now, rather than extracting the cell's content, I'd like to extract the
cell's address, so that I can then display the content of that column's
header in range B2:L2.
Example:
If the MAX function in E51 above computes the content of cell H54, rather
than displaying the content of H54 I would like to display the content of H2.
Hopefully I'm making sense...
Thanks in advance for any help you can provide!
Alain
I have a range on which I am looking for the max value:
E51=MAX($B$54:$L$54)
Now, rather than extracting the cell's content, I'd like to extract the
cell's address, so that I can then display the content of that column's
header in range B2:L2.
Example:
If the MAX function in E51 above computes the content of cell H54, rather
than displaying the content of H54 I would like to display the content of H2.
Hopefully I'm making sense...
Thanks in advance for any help you can provide!
Alain