Hi

I hadn't noticed that the Op wanted just the column letter.
That being the case then
=SUBSTITUTE(ADDRESS(1,MATCH(MAX(I1:L1),I1:L1,0)+CO LUMN(I1)-1,4),"1","")

will achieve that in a shorter form

--
Regards

Roger Govier


"JW" wrote in message
oups.com...
Good responses, but you don't really need a new function for this.
Assuming that the values are in row 2, you could place the following
formula in M2.
=ADDRESS(ROW(),COLUMN(INDEX(I2:L2,MATCH(MAX(I2:L2) ,I2:L2,0))))
That would return an absolute reference such as $L$2. You could then
use the Mid function to pull out the column letter.
=MID(ADDRESS(ROW(),COLUMN(INDEX(I2:L2,MATCH(MAX(I2 :L2),I2:L2,0)))),2,
(FIND("$",ADDRESS(ROW(),COLUMN(INDEX(I2:L2,MATCH(M AX(I2:L2),I2:L2,0)))),
2)-2))

Pretty complex formula, but it works.

HTH

Roger Govier wrote:
Hi Pascal

I think modifying your posting to
MsgBox "Max value is in " & _
Evaluate("=ADDRESS(1,MATCH(MAX(I1:L1),I1:L1,0)+col umn(I1)-1)")

will resolve the matter

--
Regards

Roger Govier


"papou" wrote in message
...
Phil
Forget my answer, it will not return the correct address.
I will have another look at it.

Cordially
Pascal

"papou" a écrit dans le message de news:
...
Hello Phil

Msgbox "Max value is in " & _
Evaluate("=ADDRESS(1,MATCH(MAX(I1:L1),I1:L1,0))")

HTH
Cordially
Pascal


"Phil" a écrit dans le message de
news: ...
I am in need of some help regarding the creation of a simple MAX
calculation
in my code.

The data is something like the following:

Col I Col J Col K Col L
12 4 7 19

How would I write a line of code that will identify that within
this
array
Column L has the largest figure?

Many thanks