Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-10-2020, 08:32 AM
thelighthouse thelighthouse is offline I need to delete several rows with zeros in a column Windows 10 I need to delete several rows with zeros in a column Office 2016
Advanced Beginner
I need to delete several rows with zeros in a column
 
Join Date: Jun 2017
Posts: 41
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
  #2  
Old 02-10-2020, 10:41 AM
DJ0691 DJ0691 is offline I need to delete several rows with zeros in a column Windows 10 I need to delete several rows with zeros in a column Office 2013
Novice
 
Join Date: Jan 2020
Posts: 18
DJ0691 is on a distinguished road
Default use a filter

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).
Reply With Quote
  #3  
Old 02-11-2020, 07:41 AM
thelighthouse thelighthouse is offline I need to delete several rows with zeros in a column Windows 10 I need to delete several rows with zeros in a column Office 2016
Advanced Beginner
I need to delete several rows with zeros in a column
 
Join Date: Jun 2017
Posts: 41
thelighthouse is on a distinguished road
Default

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

Thread Tools
Display Modes


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
I need to delete several rows with zeros in a column Macro delete table rows if cell in first column = $ Btop Word VBA 7 02-13-2018 05:36 PM
I need to delete several rows with zeros in a column Delete blank rows between the two rows that contain data beginner Excel Programming 5 12-26-2014 12:29 AM
I need to delete several rows with zeros in a column Delete All empty Rows - Print - Undo all Rows deleted Bathroth Word VBA 1 10-01-2014 01:40 PM
I need to delete several rows with zeros in a column Eliminating zeros, null values and negatives in a column jannie Excel 1 06-22-2011 07:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft