Thread: Return 2nd Lowest Value Q
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default Return 2nd Lowest Value Q
If your min value does not occur more than once:
=INDEX(A8:A34,MATCH(SMALL(G8:G34,2),G8:G34,))

Regards,
Bernd

Reply With QuoteReply With Quote