How do I create a list of items in Excel, using only items which have a quantity assigned to them in another list on a different sheet?

[raybeiler1]

I have a workbook with 4 sheets: Bid Sheet, Assemblies, Material List, and Items. I want to create a list on 'Material List' that contains only items that have a quantity assigned to them on 'Assemblies'. I do not want the quantities to come over as they will be calculated separately. The list of items that I want to check for quantities is in Column E on 'Assemblies'. I want to move the list of items that have quantities to Column B on 'Material List'. I would prefer to do this with a formula, if possible.

 

[raybeiler1]

Yes.

 

[Fluff]

Ok, how about

=UNIQUE(FILTER(Assemblies!E2:E5000,(Assemblies!C2:C5000>0)*(Assemblies!C2:C5000<>"")))

 

[raybeiler1]

This worked perfectly! Thank you so much! If you have the time and its not bothersome to you, I would love a brief explanation of this formula, particularly the <>. Thanks again.

 

[Fluff]

You're welcome & thanks for the feedback.
The <>"" is saying is the cell is not blank