A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Flipping data



 
 
Thread Tools Display Modes
  #1  
Old September 24th, 2003, 02:48 PM
mark
external usenet poster
 
Posts: n/a
Default 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.
Ads
  #2  
Old September 24th, 2003, 06:46 PM
Ken Wright
external usenet poster
 
Posts: n/a
Default Flipping data

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


  #3  
Old September 24th, 2003, 07:46 PM
Ken Wright
external usenet poster
 
Posts: n/a
Default Flipping data

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


  #4  
Old September 24th, 2003, 07:59 PM
Biff
external usenet poster
 
Posts: n/a
Default Flipping data

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

  #5  
Old September 24th, 2003, 11:07 PM
Tushar Mehta
external usenet poster
 
Posts: n/a
Default Flipping data

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:50 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.