View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
gls858 gls858 is offline
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