Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
winglj
 
Posts: n/a
Default how to flip a column upside down


Hi, everyone. I have a question about fliping the datas in one column
upside down in excell? Any functions or Macro can do it? thanks


--
winglj
------------------------------------------------------------------------
winglj's Profile: http://www.excelforum.com/member.php...o&userid=24420
View this thread: http://www.excelforum.com/showthread...hreadid=526171

  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default how to flip a column upside down

Maybe you can use a helper column.

Put 1, 2, 3, 4, ... all the way down that column.

Then select your data and sort by this column in descending order.

Then delete the helper column.

winglj wrote:

Hi, everyone. I have a question about fliping the datas in one column
upside down in excell? Any functions or Macro can do it? thanks

--
winglj
------------------------------------------------------------------------
winglj's Profile: http://www.excelforum.com/member.php...o&userid=24420
View this thread: http://www.excelforum.com/showthread...hreadid=526171


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default how to flip a column upside down

If they are sorted in Ascending order, just select one cell and click on the
"Sort Descending" button in the toolbar., or do Sort and follow the menu
for sorting descending.

Vaya con Dios,
Chuck, CABGx3



"winglj" wrote:


Hi, everyone. I have a question about fliping the datas in one column
upside down in excell? Any functions or Macro can do it? thanks


--
winglj
------------------------------------------------------------------------
winglj's Profile: http://www.excelforum.com/member.php...o&userid=24420
View this thread: http://www.excelforum.com/showthread...hreadid=526171


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF/AND/OR/DATEIF Issue...sorry...long post... EDSTAFF Excel Worksheet Functions 1 November 10th 05 12:28 AM
creating a bar graph Johnfli Excel Discussion (Misc queries) 0 October 26th 05 08:16 PM
Lookup Table Dilemma Karen Excel Worksheet Functions 2 June 10th 05 08:22 PM
up to 7 functions? ALex Excel Worksheet Functions 10 April 12th 05 06:42 PM
I typed a column in reverse order, how do I flip it (upside down). kpcane Charts and Charting in Excel 1 January 3rd 05 12:25 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"