View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hfc21
 
Posts: n/a
Default automatically hide rows with zero value

Can you format a worksheet to hide rows that result in a zero value from a
vlookup? For example we have created a report card program and when students
don't have a elective course a "0" is returned. Can this row be hidden
automatically?