[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.