software

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: www.excelforum.com/member.php...oamp;userid=23634
View this thread: www.excelforum.com/showthread...hreadid=532316
i think there is a find next blank formula that may be suitable for this
but not sure what exactly it is??--
girth69
------------------------------------------------------------------------
girth69's Profile: www.excelforum.com/member.php...oamp;userid=23634
View this thread: www.excelforum.com/showthread...hreadid=532316If your data is in column A with a label cell at the top, then in column B,
cell B2 enter:

=(A2=quot;quot;) and copy down.

Notice that if a cell in A is blank, then the cell in B is TRUE.

Pull-down:
Data gt; Filter gt; Autofilter

In column B pull-down FALSE and all the blanks (in column A) will be hidden.
Copy column A and paste where you will.
--
Gary's Studentquot;girth69quot; wrote:

gt;
gt; I have a spreadsheet with a set of data in a list in just one coloumn.
gt; this list however has some blanks in it.
gt;
gt; What i want to do is on another sheet have a shortened version of this
gt; list to avoid any blank cells appearing. Is there a formula i can use
gt; to do this??
gt;
gt; e.g current list :-
gt;
gt; 1
gt;
gt; 234
gt;
gt; 112
gt;
gt; 123
gt;
gt; needed list
gt;
gt; 1
gt; 234
gt; 112
gt; 123
gt;
gt; all i can think to do is select = and then type the reference of the
gt; top cell, drag down until i have all the necessary data and then just
gt; delete the rows where blank values appear. surely theres a way i can
gt; avoid doing this?? please help!
gt;
gt;
gt; --
gt; girth69
gt; ------------------------------------------------------------------------
gt; girth69's Profile: www.excelforum.com/member.php...oamp;userid=23634
gt; View this thread: www.excelforum.com/showthread...hreadid=532316
gt;
gt;

Copy the list to your other sheet. In this other sheet, select the whole
range from top to bottom. Press the F5 key, click on Special, click on
Blanks, click OK. Click on Edit - Delete - Shift Cells Up. Done
HTH Otto
quot;girth69quot; gt; wrote in
message ...
gt;
gt; I have a spreadsheet with a set of data in a list in just one coloumn.
gt; this list however has some blanks in it.
gt;
gt; What i want to do is on another sheet have a shortened version of this
gt; list to avoid any blank cells appearing. Is there a formula i can use
gt; to do this??
gt;
gt; e.g current list :-
gt;
gt; 1
gt;
gt; 234
gt;
gt; 112
gt;
gt; 123
gt;
gt; needed list
gt;
gt; 1
gt; 234
gt; 112
gt; 123
gt;
gt; all i can think to do is select = and then type the reference of the
gt; top cell, drag down until i have all the necessary data and then just
gt; delete the rows where blank values appear. surely theres a way i can
gt; avoid doing this?? please help!
gt;
gt;
gt; --
gt; girth69
gt; ------------------------------------------------------------------------
gt; girth69's Profile:
gt; www.excelforum.com/member.php...oamp;userid=23634
gt; View this thread: www.excelforum.com/showthread...hreadid=532316
gt;
Use Otto's method. You won't need to disturb the original worksheet in any
way.
--
Gary''s Studentquot;girth69quot; wrote:

gt;
gt; i think there is a find next blank formula that may be suitable for this
gt; but not sure what exactly it is??
gt;
gt;
gt; --
gt; girth69
gt; ------------------------------------------------------------------------
gt; girth69's Profile: www.excelforum.com/member.php...oamp;userid=23634
gt; View this thread: www.excelforum.com/showthread...hreadid=532316
gt;
gt;


that doesnt work if im trying to link the cells in the sheet to the new
desired sheet. i can copy the values across no problems but i need the
cells to be linked in. can this be done??--
girth69
------------------------------------------------------------------------
girth69's Profile: www.excelforum.com/member.php...oamp;userid=23634
View this thread: www.excelforum.com/showthread...hreadid=532316