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?

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?

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?

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?

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?

Try this *array* formula:

=INDEX(B24:F24,MATCH(MAX((MOD(COLUMN(B25:F25),2)=0 )*(B25:F25)),B25:F25,0))

--
Array formulas are entered using CSE, <Ctrl <Shift <Enter, instead of the
regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually. Also, CSE *must* be used when
revising the formula.

If/when you need to extend the range, simply revise all the reference to
Column F to Column "whatever".
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"dim" wrote in message
...
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?

Thanks folks, that seems to be working now. I really have to get my head
around this whole Ctrl-Sft-Entr thing....when to use it, when not to use
it.....what makes it different and work...etc

"RagDyeR" wrote:

Try this *array* formula:

=INDEX(B24:F24,MATCH(MAX((MOD(COLUMN(B25:F25),2)=0 )*(B25:F25)),B25:F25,0))

--
Array formulas are entered using CSE, <Ctrl <Shift <Enter, instead of the
regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually. Also, CSE *must* be used when
revising the formula.

If/when you need to extend the range, simply revise all the reference to
Column F to Column "whatever".
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"dim" wrote in message
...
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?