I need to delete several rows with zeros in a column

thelighthouse · #1 02-10-2020, 08:32 AM

I created a report from our donor software showing donations from 2018 and 2019 by individual and exported it to Excel 2016. I haven't figured out how to eliminate any donors who haven't given in the last two years in our donor software, but I'm sure there is a way to do it in Excel. Here is an example of the rows I want to delete:

I want to delete all rows that have a zero in both column C and D. I'm sure there is a way to do this in Excel but I've never done it before.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
delete rows by looking at the next column if they are equal	Pat.hooybergs	Excel Programming	1	03-25-2018 04:13 AM
Macro delete table rows if cell in first column = $	Btop	Word VBA	7	02-13-2018 05:36 PM
Delete blank rows between the two rows that contain data	beginner	Excel Programming	5	12-26-2014 12:29 AM
Delete All empty Rows - Print - Undo all Rows deleted	Bathroth	Word VBA	1	10-01-2014 01:40 PM
Eliminating zeros, null values and negatives in a column	jannie	Excel	1	06-22-2011 07:03 PM