Hide row if cell = 0

[NilesTimothyJ@gmail.com]

Ok I've a list of entries with values

essentially looks like this

ID Description Value

What i need is to hide the row if the value = 0

I'm pulling this data from a list, so essentially each cell is already
a function set to equal to another sheet ( I could hard write this in)

I'm using Excel 2007 too if it matters

[Dave Peterson]

I'd use Data|Filter|autofilter.

Then use a custom filter of not equal to 0.

NilesTimothyJ@gmail.com wrote:
>
> Ok I've a list of entries with values
>
> essentially looks like this
>
> ID Description Value
>
> What i need is to hide the row if the value = 0
>
> I'm pulling this data from a list, so essentially each cell is already
> a function set to equal to another sheet ( I could hard write this in)
>
> I'm using Excel 2007 too if it matters

--

Dave Peterson