View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pete Pete is offline
external usenet poster
 
Posts: 193
Default 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