Try this:

=INDEX(B24:F24,MATCH(MAX(B25,D25,F25),IF(MOD(COLUM N(B25:F25),2)=0,B25:F25),0))

ctrl+shift+enter, not just enter


"dim" wrote:

That.....kinda.....worked! :-)

Thanks folks. I got Rogers formula working fine, but the values are not in
order, they skip every second column, so I tried adapting Bob's formula to
get that working and typed in this:

=INDEX(B24,D24,F24,MATCH(MAX(B25,D25,F25),B24,D24, F24,0))

Unfortunately it doesnt work.....sorry for throwing questions at you all but
your help is very much appreciated.

Any ideas how to get this working?

"Bob Phillips" wrote:

In case they are not ordered

=INDEX(A1:G1,MATCH(MAX(A2:G2),A2:G2,0))



--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Roger Govier" <rogerattechnology4NOSPAMu.co.uk wrote in message
...
Hi

Try
=INDEX(A1:G1,MATCH(MAX(A2:G2),A2:G2))

--
Regards
Roger Govier



"dim" wrote in message
...
Hi,

I've been trying this with variations of the =MAX function but cant get
it
to work... :-(

I have a row of text entries as column titles in every second column,
e.g:
A1, C1, E1, G1 etc

Below those text titles, I have numeric values. e.g: A2, C2, E2, G2 etc

I want to get the highest number from row 2, and then display the column
title from that row......

......any ideas?