Merge cells if value is zero
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
|