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
 
Top