how to paste the date or the row in the reverse order

K

Kamal Dalakoti

how to paste the date of the row in the reverse order i.e
11,25,34,70,61,80,90,100 100,90,80,61,70,34,25,11
 
J

Jim Rech

You could sort it. Select the range and open the Sort dialog. Click the
Options button and pick Sort Left to Right. Then pick Descending as the
sort order.
 
G

Gord Dibben

Sort across as Jim suggests if data is in ascending order.

If random order enter this in A2 and drag across to H2

=INDEX($A$1:$H$1,8-(COLUMN(A:A)-1))


Gord Dibben MS Excel MVP


On Thu, 25 Sep 2008 03:41:00 -0700, Kamal Dalakoti <Kamal
 

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 2
paste in Reverse Order 3
How do I reverse the order of a column or row? 3
Reverse Order 1
Reverse Order 3
how to paste the values in reverse order in workbook 2
Excel 2003 - How do I reverse the order of sheet tabs in one step? 1
Chart X-Axis in reverse order! 1

Top