Thread: Return 2nd Lowest Value Q
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
shaqil shaqil is offline
external usenet poster
  
Posts: 30
Default Return 2nd Lowest Value Q
=INDEX(A8:A34,MATCH(SMALL(G8:G34,2),G8:G34,0))

check this..

On Oct 30, 2:00 pm, Sean wrote:
The formula below returns the the name associated with the lowest
value in a range. How would I tweak this formula to return the 2nd
lowest value?

INDEX(A8:A34,MATCH(MIN(G8:G34),G8:G34,0))


Reply With QuoteReply With Quote