Creating a name list from if quantity value is in adjacent cell on
Hi
I have a complete product list with all the product numbers in Colum A, and
the quantities in Colum B.
On a separate sheet I have a smaller table which I would like to populate
with the products that have a quantity value next to them only.
i.e.
Product A 1
Product B 0
Product C 0
Product D 5
Product E 25
Product F 0
Product G 2
Becomes
Product A
Product D
Product E
Product G
I know of many ways to make a macro do the task for me but I really dislike
them and would prefer to use a function string.
Thanks for your help in advance
Jive
|