I have a spreadsheet with a set of data in a list in just one coloumn.
this list however has some blanks in it.

What i want to do is on another sheet have a shortened version of this
list to avoid any blank cells appearing. Is there a formula i can use
to do this??

e.g current list :-

1

234

112

123

needed list

1
234
112
123

all i can think to do is select = and then type the reference of the
top cell, drag down until i have all the necessary data and then just
delete the rows where blank values appear. surely theres a way i can
avoid doing this?? please help!


--
girth69
------------------------------------------------------------------------
girth69's Profile: http://www.excelforum.com/member.php...o&userid=23634
View this thread: http://www.excelforum.com/showthread...hreadid=532316