J
johnb
Is this possible: I have several columns on a worksheet
each column has either text or blank cells. Is there a way
to get the cells with text to go on another worksheet,
without the blank cells. In case it will make a
difference...The text in the cells change often. ex.
below col(c).
Another question thaT will solve my problem is.. I tried
is using lookup("text",c2:c3) as result in d2. -- There
will be text in only 1 out of each 2 cells.--- when I
used this formula, in the example below, if bob was in
cell 3 it would return bob as result. If bob was in cell 2
it would return the word text. Apparently my formula is
wrong. Or it isn't meant too be used that way. Either
question will solve my problem and make my headache go
away. Thanks for taking the time to help.
col c col d
2 bob
3
4 joe
5 jack
6
7 george
8
each column has either text or blank cells. Is there a way
to get the cells with text to go on another worksheet,
without the blank cells. In case it will make a
difference...The text in the cells change often. ex.
below col(c).
Another question thaT will solve my problem is.. I tried
is using lookup("text",c2:c3) as result in d2. -- There
will be text in only 1 out of each 2 cells.--- when I
used this formula, in the example below, if bob was in
cell 3 it would return bob as result. If bob was in cell 2
it would return the word text. Apparently my formula is
wrong. Or it isn't meant too be used that way. Either
question will solve my problem and make my headache go
away. Thanks for taking the time to help.
col c col d
2 bob
3
4 joe
5 jack
6
7 george
8