Reverse Order
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 |
Reverse Order
Hi,
I may be missing something here but after pasting why don't you simply sort the row descending. Mike "PL" wrote: 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 |
Reverse Order
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 "Mike H" wrote: Hi, I may be missing something here but after pasting why don't you simply sort the row descending. Mike "PL" wrote: 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 |
All times are GMT +1. The time now is 08:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com