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

[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

 

[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.

 

[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