Filter out data

  • Thread starter Thread starter frohanss
  • Start date Start date
F

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 mor
cells.

This list does i whant to summen up on a new sheet, but i only whan
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 t
see (print) rows that |Number| is zero.
Can this be done
 
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.
 
Back
Top