Re: How to print the column # where the max row value is located?
- From: "RagDyeR" <ragdyer@xxxxxxxxxxxxx>
- Date: Sat, 4 Jun 2005 12:15:09 -0700
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:550FF1E5-FC93-4023-8E07-27A84B061496@xxxxxxxxxxxxxxxx
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!
.
- References:
- Prev by Date: check if reference exists, then return its value or return 0
- Next by Date: How does the Database Function work in Excel
- Previous by thread: Re: How to print the column # where the max row value is located?
- Next by thread: Automatically enter today's date as a static entry
- Index(es):
Relevant Pages
|
