Jan 15 2024 04:25 AM
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.