How can I sort a random list of 1000 dates in order?
How can I sort a random of of 100 dates in order?
MacBook (13-inch Mid 2010), iOS 6.1.3
The original solution of sorting dates all in one column is the way I would do this too. It takes advantage of the built-in sorting features of Numbers, and doesn't need formulas.
But if a multi-column presentation is needed, then I've figured out a way simplify my original formula so that it doesn't use modular arithmetic, which I've always found intimidating:
=SMALL(Source::$A$2:$C$7,ROW()−1+(ROWS(A)−1)×(COLUMN()−1))
All that the complicated-looking part after the comma does is assign sequential numbers to the cells in the multi-column table based on the row and column it finds itself in. SMALL then uses those sequential numbers to extract the values from the source table, smallest first.
SG