LinkBack URL
About LinkBacks
Another solution:
If in golf the lowest score is positon 1, please try:Formula:
=LET(t,BYROW(FILTER(D6:U99,U6:U99<>""),LAMBDA(r,SUM(MAP({1,10,13,16},SEQUENCE(,4,6,-2),LAMBDA(x,y,SUM(SUM(10^y*INDEX(r,,SEQUENCE(,19-x,x))))))))),XMATCH(t,SORT(t)))
Another solution:
If in golf the lowest score is positon 1, please try:Formula:=LET(t,BYROW(FILTER(D6:U99,U6:U99<>""),LAMBDA(r,SUM(MAP({1,10,13,16},SEQUENCE(,4,6,-2),LAMBDA(x,y,SUM(SUM(10^y*INDEX(r,,SEQUENCE(,19-x,x))))))))),XMATCH(t,SORT(t)))
Thanks Hans, but I decided to use the other solution after testing both methods.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks