I need a formula to sort 2k columns with only 4 numbers in each column from lowest to highest.
I need a formula to sort 2k columns with only 4 numbers in each column from lowest to highest.
You might use the SMALL() function for that. Say, your 4 numbers are in A2:A5. Enter the formula below in A8 and copy down to A11.
=SMALL(A$2:A$5,ROW()-7)
The 7 in the formula points at the row above the row in which you write the first formula. If you were to write to A10 that number must be 9.
You can copy the formula across to other columns as needed.