# How to print the column # where the max row value is located?

1. ## How to print the column # where the max row value is located?

Hello,

I have a row with 100 numbers in it. This row starts in column C and ends
in column CX. I am printing the Maximum number in this row in column B. How
can I print the number of a column that contains this maximum. In other
words, if the maximum occurs in column D, I would like to print 2 in column A.

Thank you very much!

2. ## Re: How to print the column # where the max row value is located?

On Sat, 4 Jun 2005 07:48:01 -0700, Sam <Sam@discussions.microsoft.com> wrote:

>Hello,
>
>I have a row with 100 numbers in it. This row starts in column C and ends
>in column CX. I am printing the Maximum number in this row in column B. How
>can I print the number of a column that contains this maximum. In other
>words, if the maximum occurs in column D, I would like to print 2 in column A.
>
>Thank you very much!

Look at the MATCH function:

=MATCH(MAX(2:2),2:2,0)

)
--ron

3. ## Re: How to print the column # where the max row value is located?

You're confusing the issue here when you say that you're entering the
maximum number in Column B, and you want to find which column in the row
contains this maximum number.

If it's really the maximum number, why do you have to enter it in B to look
it up?
You could simply use this in A2:

=MATCH(MAX(C2:CX2),C2:CX2,0)

If, on the other hand, you're looking for a specific number, which might
*not* be the actual largest number in the row, then you could enter that
number in B2, and this formula in A2:

=MATCH(B2,C2:CX2,0)
--

HTH,

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

"Sam" <Sam@discussions.microsoft.com> wrote in message
news:550FF1E5-FC93-4023-8E07-27A84B061496@microsoft.com...
Hello,

I have a row with 100 numbers in it. This row starts in column C and ends
in column CX. I am printing the Maximum number in this row in column B.
How
can I print the number of a column that contains this maximum. In other
words, if the maximum occurs in column D, I would like to print 2 in column
A.

Thank you very much!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1