K Kamal Dalakoti Sep 25, 2008 #1 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
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 Sep 25, 2008 #2 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.
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 Sep 25, 2008 #3 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
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
