View Single Post
  #2   Report Post  
Dave O
 
Posts: n/a
Default

I got a result by nesting the LARGE() function into an INDEX / MATCH
formula, like this:
=INDEX(A1:B5,MATCH(LARGE(B1:B5,5),B1:B5,0),1)