replace lines order

Y

Yigal

I have 100 lines of data in excel.
I want the last line (#100) to become the first line, lime
#99 to become the second.. and so on

Any idea how to do that ?
 
F

Frank Kabel

Hi
one way:
add a helper column (lets say column B)
- in B1 enter 1
- in B2 enter 2
- select cell b1:B2 and drag down for all rows
- select column A:B and goto 'Data - Sort'. Sort this range descending
with column B
- delete column B
 
J

jeff

HI,

If you have a counter on them, just sort all the
data on the counter in descending order. if you
don't already have one, add a helper column with
sequencing numbers, and then desc sort.

jeff
 
L

Leo Heuser

Yigal

Assuming data in A2:A101, enter this
formula in e.g. F2:

=OFFSET($A$2,ROW($A$101)-( ROW()-ROW($F$2)+1),0)

Copy F2 down to F101 with the fill handle (the little
square in the lower right corner of the cell)

While F2:F101 is selected copy with e.g. <Ctrl>c
and choose Edit > Paste special and "Values"
Press "OK" and <Esc> to get rid of the formulae.

Delete column A.

If you start in another cell, e.g. K4 replace
ROW($F$2) with ROW($K$4).
 
Y

Yigal

Thanks !
So simple !
-----Original Message-----
Hi
one way:
add a helper column (lets say column B)
- in B1 enter 1
- in B2 enter 2
- select cell b1:B2 and drag down for all rows
- select column A:B and goto 'Data - Sort'. Sort this range descending
with column B
- delete column B



--
Regards
Frank Kabel
Frankfurt, Germany



.
Click to expand...
 
S

Soo Cheon Jheong

Yigal,

Assuming data in A1:A100, enter this formula in e.g. B1:

=INDEX(A$1:A$20,ROWS(A1:A$20))

or

=OFFSET(A$1,ROWS(A1:A$20)-1,0)

or

=INDIRECT("A"&101-ROW())


Copy B1 down to B100 with the fill handle


--
Regards,
Soo Cheon Jheong
Seoul, Korea
http://excel/hompy.com
_ _
^¢¯^
--
 
Top