Filter out data

[frohanss]

Hi,

i am working on a workbok and have some sheets with a list of data.
This is a product list.
Looks like:
Dimensjon | Text | Type | Number | And some more cells.

This list does i whant to summen up on a new sheet, but i only whant the Rows where |Number| is bigger than zero.
How can i do this?

And another list i have is mutch the same, but here i don't whant to see (print) rows that |Number| is zero.
Can this be done?

[Dave Peterson]

Select your range
Data|Filter|Autofilter

You'll see little dropdown arrows on the top row of your selection.

Click on the dropdown arrow in the Number column
choose custom
Then choose "is greater than" and type 0 in the righthand box (or use the
dropdown to show the values).

Then you can print.

Finally, you can use data|filter|show all to keep the filter but show all the
data.

Or you can use data|filter|autofilter to remove the filter.

frohanss wrote:
>
> Hi,
>
> i am working on a workbok and have some sheets with a list of data.
> This is a product list.
> Looks like:
> Dimensjon | Text | Type | Number | And some more
> cells.
>
> This list does i whant to summen up on a new sheet, but i only whant
> the Rows where |Number| is bigger than zero.
> How can i do this?
>
> And another list i have is mutch the same, but here i don't whant to
> see (print) rows that |Number| is zero.
> Can this be done?
>
> --
> frohanss
> ------------------------------------------------------------------------
> frohanss's Profile: http://www.excelforum.com/member.php...o&userid=26917
> View this thread: http://www.excelforum.com/showthread...hreadid=425061

--

Dave Peterson