LinkBack URL
About LinkBacks
Try this, i can't make out your row numbers in the picture so you will need to modify it
Put the formula in your Rank 1 cell and copy down as far as you need.
=IFERROR(INDEX(C1:C15,MATCH(LARGE(K1:K15,ROW(1:1)),K1:K15,0)),"")
Try this, i can't make out your row numbers in the picture so you will need to modify it
Put the formula in your Rank 1 cell and copy down as far as you need.
=IFERROR(INDEX(C1:C15,MATCH(LARGE(K1:K15,ROW(1:1)),K1:K15,0)),"")
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.Originally Posted by Jacc
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks