#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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). |
#3
|
|||
|
|||
This is why I am a member of this forum. That method worked like a charm. Thank you.
|
|
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 |