I have data in cell A1:A1000.
I want to have data in cell A1000 to be in A1, A999 to A2 etc.
What do I need to do?
Thanks,
I have data in cell A1:A1000.
I want to have data in cell A1000 to be in A1, A999 to A2 etc.
What do I need to do?
Thanks,
insert new column A number down from 1to 1000, select all data ,sort decending on col a
delete col a
or put
=INDEX($A$1:$A$1000,1000-(ROW(A1)-1)) in a spare column row 1 and drag down
Last edited by martindwilson; 07-16-2009 at 10:15 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
In B1,
=INDEX($A$1:$A$1000,1000-(ROW()-1))
and copy down for all your data
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Thanks for the quick reply.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks