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

  • Thread starter Thread starter Kamal Dalakoti
  • Start date Start date
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
 
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.
 
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
How do I reverse the order of a column or row? 3
paste in Reverse Order 3
Reverse Order 1
Reverse Order 3
how paste transpose reverse? 2
cell order 7
how to paste the values in reverse order in workbook 2

Back
Top