Excel: I want to delete rows that balance to zero.

[Robotron]

Is there an easy way to delete rows which, when subtotaled, equal zero? Any help appreciated.

Phil

 

[GlennUK]

What about just filtering them out, using Autofilter?


Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[Robotron]

Well, I actually want to delete them, not just filter them.

Phil

 

[xlbo]

1) Add a sum to the end of each row
2) Put autofilter on
3) Filter for the end column where = 0
4) delete all rows
5) unfilter, leaving only those rows that do not balance to zero

Rgds, Geoff

"Having been erased. the document thjat you are seeking. Must now be retyped"

Please read FAQ222-2244 before you ask a question

 

[Robotron]

Thanks. That works.

Phil