Reverse Order

P

PL

Hi

If I have a row of numbers,

Eg, 1 2 3 4

& I would like to copy & paste them, but when I paste them I want them to be
in Reverse Order.

Eg 4 3 2 1

how do I do so ?

Thanks
 
M

Mike H

Hi,

I may be missing something here but after pasting why don't you simply sort
the row descending.

Mike
 
M

Mike H

Hi, Again,

If your example is oversimplified and sort doesn't work you can reverse the
order of a row like this which assumes your data are in A1 - K1. Put this
formula in a cell and drag right

=INDEX($A$1:$K$1,COUNTA(A1:$K$1))


Mike
 
Top