Copying the Data in reverse by using Formula/Paste Special

[Venkata Krishna]

Dear Friends,

I request you all kindly let me know while doing paste special whether we can copy the data in reverse manner instead of regular pattern. Here, I would like to explain my query in detail.

As you all aware that we use paste special command for multipurpose requirements such as breaking the links/transpose etc. But, here I need to copy the data from last row figure as first in the same context first one as final.

Ex: if Data is 123456 and if we paste the data by using paste special, data will be same may be in in row /column. Here, I wanted to copy the data as 654311 which means reverse. Hence, kindly guide me whether is there any command/formula for doing the same.

Your kind support for the same would be appreciated.

Thanks in advance

[XOR LX]

Hi,

You mean if you have e.g. in A1:A6 the numbers 1, 2, 3, 4, 5, 6 then you would like, in e.g. B1:B6 to see 6, 5, 4, 3, 2, 1?

If so, in B1 and copy down:

=INDEX($A$1:$A$6,ROWS($A$1:$A$6)-ROWS($1:1)+1)

Regards