Row elimination problem

[zerconian]

I am a novice Excel user and this forum has been extremely helpful i
the past.
I have an inventory list with one of the columns being quantity.
How does one eliminate the rows (hundreds ) with 0 in the qantit
column in order to compact the list to only what is in stock?
Thanks in advance for any help

 

[JE McGimpsey]

There are many ways, which a search in the newsgroup (not forum)
archives will give you:

http://groups.google.com/advanced_group_search?q=group:*excel*


However, from your description, I'd say that advanced filter is what
you're looking for. See Help and Debra Dalgleish's excellent
introduction at

http://contextures.com/xladvfilter01.html

 

[DDM]

Zerconian, the AutoFilter feature will do the trick. Click in the data, then
Data (menu) > Filter > AutoFilter. In the Quantity column, click the down
arrow and select Custom. In the Custom AutoFilter dialog box, set up the
criteria to say Inventory is greater than 0, then OK. (BTW, Data > Filter >
AutoFilter will remove the filter.)

A more drastic measure: Data > Filter > AutoFilter. In the Quantity column,
click the down arrow and select 0. Select all the rows and delete them. Then
Data > Filter > AutoFilter.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com

 

[Gord Dibben]

zerco

Right-click on the worksheet tab and "move or copy".

Checkmark in "create a copy".

On that copied sheet...

Select the quantity column then Data>Filter>Autofilter.

Filter for 0 in that column.

All rows with 0 will be displayed. Select these.

Edit>Go To>Special>"Visible cells only">OK

Edit>Delete Row(answer yes)

Done. Turn off Autofilter.

If happy, delete the original sheet.

Alternate method which will re-arrange your rows, perhaps not what you want.

Select all the columns. Data>Sort>Sort by quantity column>ascending.

All 0's will rise to the top. Select these and Edit>Delete Row.

Gord Dibben Excel MVP