View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nick nick is offline
external usenet poster
 
Posts: 192
Default how do i get field name from result of MAX or LARGE function

This is probably easy one but I cant figure it out.
I want to get the field name/label from the same row in the column to the
left of the result of a MAX or LARGE function. Tried LOOKUP but data is not
in order.

e.g.

A B
ReasonA 23
ReasonB 44
ReasonC 17 I would like MAX function to return 'Reason B'