to find the row of the maximum value

[sunil.s]

Hi,

I want a formula to find the row of the maximum value

please help me out

a 1 8 15
b 2 9 16
c 3 10 17
d 4 11 18
e 5 12 19
f 6 13 20
g 7 14 21


for this the result should be 7th row , 14th row, 21st row etc

Thanks
Sam

 

[Glen Mettler]

=max(firstcol&row:lastcol&row) ie =max(a1:a100)

Glen

 

[sunil.s]

Glenn,

I want the row# where the maximum value exists? please give me
suggestions

Thanks
Sam

 

[Pete_UK]

Use the MATCH function with the MAX function as the search parameter -
this will give you the (relative) position of the matching item. Excel
Help gives further details.

Hope this helps.

Pete