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 time a new weight is entered in a column, I need it to calculate largest to smallest in that row. Then I need to duplicate the calculation for 40 independent rows. Then there will be a total column that only totals the largest 3 weights in each row.
=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!
