Referencing a row with a maximum value array?
 

Does anyone know how to reference the row number that a maximum value appears
in. I don't want to reference the value but the actual row. Here is what I
am putting in but it is now correct
=row(max(column_array)

Where the column array would be; D4:D10

Referencing a row with a maximum value array?
 

=MATCH(MAX(D4:D10),D4:D10,0)+3

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"pete" wrote in message
...
Does anyone know how to reference the row number that a maximum value
appears
in. I don't want to reference the value but the actual row. Here is what
I
am putting in but it is now correct
=row(max(column_array)

Where the column array would be; D4:D10