Yes, that should work but i still like to merge the text to only one cell,
with new row for every textcell. Another problem, will this filter work if
you have several columns with numbers and every column should have there own
list with text.
A B C D E etc.
1 Cars 1 0 1
2 Dogs 0 1 1
3 Cats 1 0 0
4 Candy 0 0 1
5 icecream 0 0 0

New cell 1:
Dogs
Candy
Icecream

New cell 2:
Cars
Cats
Candy
Icecream

etc. etc.

/Johan

"Dave Peterson" skrev:

Maybe you could select column B
Data|Filter|autofilter
show the rows where column B equals 0
delete those visible cells
(Or copy those visible cells to a new worksheet????)

You may just want to filter values that are not equal to 0.

The data will still be there--just in case you need it.

sandman007 wrote:

Yes, that is correct, that is a much simplier way of explaining it , haven´t
thought about it in that direction before.

/Johan

"Dan R." skrev:

So basically you want to delete the rows where column B is not 0?

--
Dan



--

Dave Peterson