LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 209
Default Reversing data in columns

Gary''s Student wrote:
1. pick an un-used column and enter:
=ROW() and copy down

2. copy the column and paste/special/values back onto the column

3. sort the worksheet by the new column DESCENDING

this will reverse all the rows.


I thought about that also but wouldn't that put the date field BELOW the
data instead above it. Of course I'm assuming the following layout based
on the OP's description. You know what they say about assuming:-)

1 12/12/09
2 data1
3 data2
4 12/13/09
5 data3
6 data4

sorts to
6 data4
5 data3
4 12/13/09
3 data1
2 data2
1 12/21/09

gls858
 
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
Reversing the order of data separated by commas within a cell? rome330 Excel Discussion (Misc queries) 5 February 9th 09 07:21 PM
Reversing Data Peter[_8_] Excel Discussion (Misc queries) 1 December 14th 07 04:00 AM
Pivot Table is reversing data mike lewis in texas Excel Discussion (Misc queries) 2 November 20th 07 04:05 PM
Reverse a spreadsheet reversing columns and rows? Becca Excel Worksheet Functions 3 August 9th 06 08:44 PM
Reversing First & Last Name Magic Excel Worksheet Functions 3 April 6th 05 08:18 PM


All times are GMT +1. The time now is 05:36 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"