Material List

[AEHNLE]

Hi, I work for a small construction company and I am working on a material
list for jobs. What I need is a function that will go through the list and
remove any items that do not have a quantity in the row. I would apprciate
any help that I can get.

 

[Glenn]

Hi, I work for a small construction company and I am working on a material
list for jobs. What I need is a function that will go through the list and
remove any items that do not have a quantity in the row. I would apprciate
any help that I can get.

Do you want to remove the rows, or hide them?

http://www.contextures.com/xlautofilter01.html

 

[Eduardo]

Hi,
take a look at CPearson web, go to the middle of the page

http://www.cpearson.com/excel/deleting.htm

if this helps please click yes thanks

 

[Pete_UK]

I think the easiest way is to apply Autofilter to the quantity column
(or to a helper column which has a formula =quantity_cell) and select
Custom filter from the filter drop-down and then choose not equal to
and enter zero. This will hide all the rows with zero quantity, rather
than deleting them, so they are available for next time.

Hope this helps.

Pete

 

[AEHNLE]

Hide them, sorry for the confusion

 

[AEHNLE]

Pete thanks for the tip. It did exactly what i wanted, although i was hoping
that it would shorten up my list instead of just hiding the contents of the
cells. is there any way to hide the entire rows that are not needed so that
my list shrinks?
--
Thanks,

Andrew

I think the easiest way is to apply Autofilter to the quantity column
(or to a helper column which has a formula =quantity_cell) and select
Custom filter from the filter drop-down and then choose not equal to
and enter zero. This will hide all the rows with zero quantity, rather
than deleting them, so they are available for next time.

Hope this helps.

Pete

 

[Pete_UK]

Well, that's how the filter works - it hides a complete row if the
cell in that row doesn't match the criteria that you have set in the
filter drop-down, so all those rows with a quantity of zero should be
hidden.

Are you using multiple rows for one record?

Pete