Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I reverse name order from Last, First to First Last in Exc | Excel Discussion (Misc queries) | |||
Histogram in reverse order | Excel Worksheet Functions | |||
Reverse chart order | Charts and Charting in Excel | |||
reverse order | Excel Discussion (Misc queries) | |||
Reverse order in column | Excel Worksheet Functions |