Thread: I need to delete several rows with zeros in a column
View Single Post
 
Old 02-10-2020, 08:32 AM
thelighthouse thelighthouse is offline Windows 10 Office 2016
Advanced Beginner
  
Join Date: Jun 2017
Posts: 42
thelighthouse is on a distinguished road
Default I need to delete several rows with zeros in a column
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.
Reply With Quote