View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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