Global Deletion of Specific Rows

  • Thread starter Thread starter Ernie
  • Start date Start date
E

Ernie

Hi, Everyone.

My wife is employed in the finance office of a municipality. She is working
with a list of payroll checks. This list is extracted from a mongrel piece
of financial software. The Excel schedule has three columns, with over
4,000 rows. The three columns represent check numbers, check amounts, and
check dates.

The goal is to delete every row with a zero check amount (0.00),
irrespective of check numbers or check dates. These zero rows represent an
employee's salary that has been directly deposited. Rather than a tangible
check, these zero rows represent only a tracking system in the mongrel
software. They are interspersed among the 4,000 rows. However, they are
cumbersome and needless in the excel spreadsheet, and must be deleted.

Is there a global command to delete only these zero rows?

Thanking you in advance for your help,

Ernie & Elizabeth
 
Select the amount column.
Goto Autofilter, menu Data>Autofilter
This will add a dropdown in the first row
Click the dropdown and select the zero amount
This will then show only rows with a zero amount
Select those rows and delete them
Remove the Autofilter (Data>Autofilter)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
I think I'd just apply data|filter|autofilter, then show those 0's, then delete
the visible rows.

You could sort by that field and it could go a bit quicker, but for 4000 rows,
probably not too much quicker.
 
Dear Dave and Bob:

Thank you so much. I forwarded both replies to my wife.

Your expertise and kindness are deeply appreciated.

Our best to you both,

Ernie & Elizabeth
 
Back
Top