How to get results in following cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

You could use autofilter, show non blanks. It's quick and easy.

Matthew
 
I'd apply data|filter|Autofilter to the column B in the original worksheet.

Then filter to show different from 0 (or greater than 0) and then copy those
visible rows/cells to the second worksheet.
 
Another play to try ..

Assume source data as posted in Sheet1's cols A and B, from row2 down

In Sheet2,

In A2:
=IF(OR(Sheet1!B2="",Sheet1!B2=0),"",ROW())
Leave A1 blank

In B2:
=IF(ROWS($1:1)>COUNT($A:$A),"",INDEX(Sheet1!A:A,SMALL($A:$A,ROWS($1:1))))
Copy B2 to C2. Select A2:C2, copy down to cover the max expected extent of
data in Sheet1. Hide away col A. Cols B and C will return only the lines from
Sheet1 where "Cases Ordered" is not blank/contains zero, all neatly bunched
at the top. As the source data is updated in Sheet1's col B, Sheet2 will
automatically display the results.
 
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
 
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
 
Back
Top