automatically hide rows with zero value

G

Guest

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?
 
P

Pete

Autofilter will allow you to hide rows where a cell contains zero
(select Custom | Not Equal To | and enter zero), but this will be
manual rather than automatic.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically Hide rows with a value of zero 2
Automatically hide/unhide rows 5
Automatically Hide Rows 10
Excel - if cells = 0, how to conditionally hide rows in chart 1
Hiding/Unhiding Rows Automatically 1
NumberFormat for small non-zero numbers? 2
hide row based on cell value 2
hide row when adjacent column has zero(0) 1

Top