Flipping data

Is there a functional way to flip a column of data. So
that if I have 10 numbers in range A1:A10, the number in
cell A10 would then be at the top of the column, and the
number that was originally in A1 would be at the bottom.

[This followup was posted to microsoft.public.excel.worksheet.functions
with an email copy to mark.
Please use the newsgroup for further discussion.]

If your data are in A1:A5, select B1:B5. Array enter the formula
=INDEX(A1:A5,ROWS(A1:A5)-ROW(A1:A5)+ROW(A1))

Adjust as needed to the size of your own data set.

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site
--
An array formula is entered with CTRL-SHIFT-ENTER rather than just
ENTER. If done correctly, XL will display curly brackets { and }
around the formula

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Is there a functional way to flip a column of data. So
that if I have 10 numbers in range A1:A10, the number in
cell A10 would then be at the top of the column, and the
number that was originally in A1 would be at the bottom.

Put 1 to 10 in the 10 cells next to it, select all the data and sort in descending order on the
helper column. Then just delete the 1 to 10.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



"mark" wrote in message ...
Is there a functional way to flip a column of data. So
that if I have 10 numbers in range A1:A10, the number in
cell A10 would then be at the top of the column, and the
number that was originally in A1 would be at the bottom.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/2003

Apologies if this turns up twice, but posts seem to being deleted at the moment (Though none of
the virus attachments seem to be going - Go figure!!)

Put 1 to 10 in the 10 cells next to it, select all the data and sort in descending order on the
helper column. Then just delete the 1 to 10.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



"mark" wrote in message ...
Is there a functional way to flip a column of data. So
that if I have 10 numbers in range A1:A10, the number in
cell A10 would then be at the top of the column, and the
number that was originally in A1 would be at the bottom.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/2003

Hi Mark,

Here's one way:

In B1 enter 1 and fill down as a series to B10. Select the
range A1:B10. Then sort on column B descending. Then you
can delete the number series in B1:B10.

Biff

-----Original Message-----
Is there a functional way to flip a column of data. So
that if I have 10 numbers in range A1:A10, the number in
cell A10 would then be at the top of the column, and the
number that was originally in A1 would be at the bottom.
.