Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
reverse cut and paste
I have the following: Jan Feb Mar
I want to cut and paste to Mar Feb Jan. How to go about it? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
reverse cut and paste
Hi
With months in column A, starting from A1, enter into cell in another column (p.e. B1) the formula =OFFSET($A$1,COUNTA($A:$A)-ROW(),0) , and copy it down for same amount of rows as you have months. Probably you have to adjust the formula accordingly your table setup. PS. It is impossible to do through buitl-in cut/copy and paste. At least without some helping column - p.e. with month numbers - and sorting. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "chiuinggum" wrote in message ... I have the following: Jan Feb Mar I want to cut and paste to Mar Feb Jan. How to go about it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|