LinkBack URL
About LinkBacks
not sure what MS excel version you have but you can try this formula in M3 copy across, it should spill down automatically.
Formula:
=XLOOKUP(SORT($K$3:$K$14,1,-1),$K$3:$K$14,B$3:B$14,0,0)
not sure what MS excel version you have but you can try this formula in M3 copy across, it should spill down automatically.
Formula:=XLOOKUP(SORT($K$3:$K$14,1,-1),$K$3:$K$14,B$3:B$14,0,0)
<----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks