Reverse Order

  • Thread starter Thread starter PL
  • Start date Start date
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
 
Hi,

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

Mike
 
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

Similar Threads

Reverse Order 1
Reverse Order 3
paste in Reverse Order 3
Autofill- Reversing Order 4
Reversing text 11
warning message 2
Reverse order of numbers in a column 1
Column Order Reversal... 3

Back
Top