Copper Contributor

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.



2 Replies




With Office 365 or Excel for the web you can apply this formula.



Thank you!