Pasting data in the reverse order

You might have come across with situation where you wanted to paste your data in reverse order. In the example below we want the numbers in Data column in reverse order. This can be done using excel formula.

Data	Reverse Data
1	5
2	4
3	3
4	2
5	1

Following formula can be used:

=INDEX($A$2:$A$6,ROWS(A2:A$6))