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.

The simple way to do a quick delete is to click on the header row and then click 'Sort & Filter' in the toolbar, then click 'Filter'. This will place a filter down arrow at the top of each column. Now filter for '0' in both the 2019 and 2018 columns.

This will leave you with just the rows you want to delete. Select those rows and hit the delete button. If you don't like the results, just do an Undo (Ctrl + z).

This is why I am a member of this forum. That method worked like a charm. Thank you.