View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Hide row if cell = 0

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