remove rows that have 0 in one cell

[jjpcpanama]

have two columns in a spreadsheet listing the number of birds seen and the name of the bird. I want to remove all the rows that have a 0 for number of birds seen. I can go one by one, however I...

[dflak]

Probably, the easiest way to do this is with a pivot table.

I took the liberty of converting your range of data into an Excel Table. One of the advantages of Excel Tables is that they know how big they are, so pivot tables and charts built on them will expand to encompass new data automatically.

In this case, I also added another column called Is Zero with the formula =[@Sightings]=0

Then I used Insert > Pivot Table and created a pivot table using Is Zero = False as the Filter, Type as the Row and Sightings as the value.

You will notice that the pivot table alphabetized the bird type automatically. Now that it is i the pivot table, you can also sort this by number of sightings and pare it town to the top 20 or whatever by sighting.

With normalized data in a table (and possibly some helper cells), and a pivot table you can do almost anything.

P.S. I recommend sorting your data on Sheet1 by type to make finding and updating totals easier. Also, you can use conditional formatting to highlight if the number is zero.

Also if the date of sighting is important, you can, with some modification, produce the same results and keep track of first and last sightings.

[Jhon Mustofa]

OPS...sorry i'm wrong room...