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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top