Forum Discussion
Sorting col large to small with duplicates and putting into a vertical table
I am trying to sort the horizonal values in the first row based upon the values in the second row and have the result be similar to the vertical table to the right I keep getting #num or it only ret...
This is futures but a simple solution is coming to a computer near you!
Using modern Dynamic Arrays the formula in cell Q2
will be
= SORT( TRANSPOSE(data), 2, -1 )
I will be so thankful to get rid of direct cell referencing and the practice of filling down single-cell formulas when a simple array is all that is needed!
PeterBartholomew1 , I used this to check if "traditional" formulas are correct...