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

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

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.



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

--

Dave Peterson

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,SM ALL($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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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

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

Thank you Max, it is exactly what I was looking for. Just perfect

"Max" wrote:

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,SM ALL($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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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

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

"Dave Peterson" wrote:

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.



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

--

Dave Peterson

welcome, albertmb
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"albertmb" wrote in message
...
Thank you Max, it is exactly what I was looking for. Just perfect