Reverse a "row" of numbers (flip flop them)?
MartinW
I think I almost had it, at least I had it once.
Step 1: In helper row, put 1 in the first cell and drag (with ctrl or shift
?) held down.
Step 2: Select ? (highlight ? with control or shift held down?????)
I am so close.
"MartinW" wrote:
Hi wannabe,
In row 51(helper row) put 1 in the first cell and drag across as far as
needed, hold down ctrl and let go the left button then let go ctrl.
Then select all of your data including your helper row
and go to DataSort then click on the options button
and select Sort left to right then click OK
then select row 51, descending and OK
HTH
Martin
"wannabe68" wrote in message
...
I have 50 rows of numbers, with the last number being last number in the
sequence. I want to reverse these numbers, so the most recent number is
the
first number. How do I do this? Been up all night trying to figure this
out. Thanks for you help, I just have to get some sleeeeeeeeeeeeeeep!
|