Hi David

Maybe I confused you with my earlier posting.
I can now see that row 1 contains the numbers 1 to 5. These are not
necessary to obtain the column number, as we are treating B as 1 by
starting with column B

=MATCH(LARGE(B2:F2),B2:F2))
will return 5 (as opposed to 6, being the column number for column F)

--
Regards

Roger Govier


"David" wrote in message
...
Thank You. INDEX works for the MAX number in the list and I am sure I
can
modify it slightly in case they want second largest number or 10th. If
anyone
knows of it right off please send it but Thank You for this point in
the
right direction.

"Teethless mama" wrote:

=INDEX($B$1:$F$1,MATCH(MAX($B2:$F2),$B2:$F2,0))
drag down as far as needed

"David" wrote:

I have a chart of numbers, lets say it is 10 by 10 with different
amounts in
each. I want to find which column, for each row, has the Largest
number. I
know I need to use the LARGE formula but I don't want it to tell me
what the
number is but which column it is in.

Example
A B C D E F G H I
1 2 3 4 5 NUM LRG
1 09 12 08 04 15 1 5
2 17 02 08 20 03 2 4
3 02 01 07 05 03 3 3
4 25 06 17 18 09 4 1

I would then have column H have 1 - 4 and Column I would have which
row the
largest number in:

I know I can use the LARGE formula like =LARGE(B2:F2,1) to give me
which
number is largest but how do I then tell it so show me which column
in B1:F1?