to find the row of the maximum value

  • Thread starter Thread starter sunil.s
  • Start date Start date
S

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
 
Glenn,

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

Thanks
Sam
 
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
 
Back
Top