Can we Copy Reversely

[KishorKK]

Hi Team,


Can anyone tell me how to copy & paste reversely i mean right to left


Like if we have data like 2013,2012,2011
and we need it like 2011,2012,2013.

i am trying to do with index / match but it's not working. Please help me with this. Thanks

 

[John Jairo V]

Hi!

Try with

=INDEX($A1:$C1,COLUMNS(A1:$C1))

And drag it to the right.

Blessings!

 

[Biplab4444]

Hi Team,


Can anyone tell me how to copy & paste reversely i mean right to left


Like if we have data like 2013,2012,2011
and we need it like 2011,2012,2013.

i am trying to do with index / match but it's not working. Please help me with this. Thanks

Hi....
I have an alternative solution for your problem, hope it will serve your purpose
you may try sort your data left to right

 

[bobhc]

If you have row elements of 1,2,3,4 then you want them to be in a row, but in the order 4,3,2,1 To reverse a row use this:

=INDEX($A$2:$D$2,1,COUNT(A$2:$D$2))



The range to be reversed is A4:D4. Note that the first column in the count is not anchored so this value gets walked down from 4 to 3 to 2 to 1 as you copy the cell to the right.

 

[John Jairo V]

@bobhc: The disadvantage of the formulae you propose is whether the origin is no blank cells, or if all data is not numeric. For the initial instance of the op. works, but thinking about the possible contingent I prefer the method that I showed up.

It's just a comment. Blessings!

 

[bobhc]

Good day @John Jairo V

Well made points as you say, I answered the OP but your answer takes in to account more options, very good point.


.

 

[KishorKK]

HI All,

Thanks for the replies. Got the answer