How to get results in following cells
Thank you for your time but what I was looking for was something that works
automatically, Max got it right for me. Thank you once again
"Matthew" wrote:
On 9 Sep, 17:02, albertmb wrote:
Hi everyone, I need some help.
In sheet 1 I have a product list from which I order items every week:
A B
1) ITEM Cases Ordered
2) Banana 3
3) Apples 0
4) Oranges 1
How can I get results in sheet 2 eliminating those items from which I
haven't orderd but in following cells?
A B
1) ITEM Cases Ordered
2) Banana 3
3) Oranges 1
The following is what I managed so far:
A B
1) ITEM Cases Ordered
2) Banana 3
3)
4) Oranges 1
Thank you in anticipation
You could use autofilter, show non blanks. It's quick and easy.
Matthew
|