how to remove rows containing 0's?

[Pradeep Pradhan]

Column C = Column (A+B)

Result of A + B in C have a few cells having 0 value.

Using find formula to highlight cells with 0 value is not working.

How to solve this?

Thanks

pradeep

 

[kchiba]

Hi Pradeep,

You can use filter to filter the data.

Or Conditional Formatting to highlight the cell with 0

 

[Somendra Misra]

Hi Pradeep,

I don't think there is any function in Excel to delete complete row. It would require VBA to delete rows with a certain value.

Or you can use the suggestion given by kchiba or use conditional formatting to highlight rows with value 0 and than delete them manually.

But if you require to automate the process you have to use VBA. Kindly, refer this link and see if this is useful.

http://www.extendoffice.com/documents/excel/815-excel-remove-rows-based-on-cell-value.html

Somendra.

 

[Pradeep Pradhan]

thanks

 

[SirJB7]

Hi, Pradeep Pradhan!
A quick question: how do you manage to read on white font over light orange background? It's insane.
Regards!

 

[azumi]

Maybe like this? check the file

 

[Pradeep Pradhan]

Thanks for your advise. I ,ll try to improve on this.

cheers

pradeep