#1   Report Post  
Posted to microsoft.public.excel.misc
PL PL is offline
external usenet poster
 
Posts: 58
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I reverse name order from Last, First to First Last in Exc Annie Lord Excel Discussion (Misc queries) 4 April 22nd 23 02:10 AM
Histogram in reverse order Brandon Schmidt Excel Worksheet Functions 1 November 20th 08 06:21 PM
Reverse chart order Divinite Charts and Charting in Excel 2 May 23rd 07 03:48 PM
reverse order Lamb Chop Excel Discussion (Misc queries) 2 June 20th 06 03:37 PM
Reverse order in column D Excel Worksheet Functions 3 July 4th 05 07:22 AM


All times are GMT +1. The time now is 08:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"