reverse cut and paste

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following: Jan Feb Mar

I want to cut and paste to Mar Feb Jan. How to go about it?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

drag formula down from columns that go acros 3
2 dimensional date sort 1
Excel Help with dates 2
Pivot from multiple sheets 1
Summing a non continuous range 7
to lookup data for 'today()' 2
Specify columns to add for months MTD Diff 3
Specify a column by the month to calculate it's data 5

Back
Top