How can I paste data in reverse order?

Question

How can I paste data in reverse order?

Anonymous

Hi there,

I was wondering how to paste data in reverse order.

Any ideas?

Thanks :)

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

7 answers

Answer 1

Anonymous

With your current data in A1:A11

Enter this in B1 then copy down.

=INDEX($A$1:$A$11,11-(ROW(A1)-1))

Gord

Answer 2

Anonymous

Another method is to enter the numbers 1 to 11 in a column, select both columns and sort the numbers largest to smallest.

Gord

Answer 3

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Answer 4

Ashish Mathur 100.9K Volunteer Moderator

Hi,

With data in range A2:A12, enter this formula in cell B2 and copy down

=INDEX($A$2:$A$12,COUNTA(A2:A$12),1)

Hope this helps.

Answer 5

Thank you all for your quick responses

@Gord Dibben

@Ashish Mathur

I guess it's my fault. I wasn't clear.

Process:

First, the user selects a range of cells manually.

Then, we have the add-in or button: its code should identify the active range and then paste it in reverse order, horizontally or vertically, into the cell of our choice.

In such case I'll build 2 separate buttons.

Any ideas?

Cheers

Share via

How can I paste data in reverse order?

7 answers