G Guest Jan 5, 2005 #1 How do I sort a range, column or rows, in a simple reverse order? 212, 456, 125, 345, becomes 345, 125, 456, 212.
How do I sort a range, column or rows, in a simple reverse order? 212, 456, 125, 345, becomes 345, 125, 456, 212.
E Earl Kiosterud Jan 5, 2005 #2 raisin, A simple way is to put ascending numbers in an extra column: Put 1 in the first, then fill down with the Fill Handle holding Ctrl. Now do a sort of the whole thing, descending, on that column. Be careful that all of your columns get sorted.
raisin, A simple way is to put ascending numbers in an extra column: Put 1 in the first, then fill down with the Fill Handle holding Ctrl. Now do a sort of the whole thing, descending, on that column. Be careful that all of your columns get sorted.
