Thread
:
Create List based on cell data
View Single Post
#
2
Dave O
Posts: n/a
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)
Reply With Quote