View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike K Mike K is offline
external usenet poster
 
Posts: 104
Default Offset of a minumum

Oh Wise Ones,
I've got and easy one for you. I have tried several
different setups of trying to find the offset of a minimum. I have a range in
column D (D12:D200) and in column A is the corresponding date. I need to
find the min in col D and find the matching date in col A offset (0,-3) I
believe it would be. Not sure if I use Min of offset or offset of min.
Niether seem to get me what I want. Any help would be appreciated.

Thanks,
Mike