Sort one row of numbers with results in desending order in another row.

Question

sort a row in descending order.&nbsp; place that value with a number showing that descending order in a new row.exampletotal values&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 111&nbsp;333&nbsp;222&nbsp; 444&nbsp; 555 so on.numerical descending order in this row&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp;x&nbsp; &nbsp; &nbsp;x&nbsp; &nbsp; &nbsp; x

peterbartholomew1 · Answer

DenMof&nbsp;Sorting 'numbers' by 'order'= SORTBY(numbers, order,-1)

Forum Discussion

Sort one row of numbers with results in desending order in another row.

1 Reply

Resources