View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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