On 21/06/13 13:56, Carlos E. R. wrote:
(1) add an additional column that contains monotonically increasing integers. Reverse sort on that column. Then delete the column.
Yep. I thought of this way two minutes after posting. Usually writing a post has this effect on me, finding the answer, or an answer ;-)
I added a column, first cell is 1, next is previous +1. Then copy paste values to destroy the formula, then sort by that column. I think there is another way to fill a column with consecutive numbers, but that's the way I remember. Do all that on an auxiliary sheet, copy back to original table the resulting table less the sorting column. Otherwise, add a column, number it, sort, delete column.
That's a bit of a clumsy method - if you manually enter 1, 2, 3 in the first three cells respectively, then select the three cells, you can use the drag handle lower right of the selection to extend the sequence down the column... Dx -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org