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! |
On Sat, 4 Jun 2005 07:48:01 -0700, Sam 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 |
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" wrote in message ... 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! |
All times are GMT +1. The time now is 12:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com