Ask Your Question

Revision history [back]

Copy column A to column B, then Data -> Sort Ascending.

Copy column A to column B, then Data -> Sort Ascending.

Edit: If the numbers need to be sorted using only a formula ("automatically"), then if we assume the numbers are in column A starting from A1, fill column B with =LARGE(A:A,ROW(A1))

Copy column A to column B, then Data -> Sort Ascending.

Edit: If the numbers need to be sorted using only a formula ("automatically"), then if we assume the numbers are in column A starting from A1, fill column B with =LARGE(A:A,ROW(A1))=SMALL(A:A,ROW(A1))