Forum Discussion
Excel
I would like to know how to set up my sheet to automatically sort a set of data in each row from largest to smallest. There will be 10 columns of data in each row. The data will be weights. Each tim...
=DROP(REDUCE("",SEQUENCE(ROWS(B2:K15)),LAMBDA(x,y,VSTACK(x,LET(z,TOROW(SORT(TOCOL(CHOOSEROWS(B2:K15,y)),,-1)),HSTACK(z,SUM(TAKE(z,,3))))))),1)
With Office 365 or Excel for the web you can apply this formula.
Thank you!
