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
 
Back
Top