close

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 quot;0quot; is returned. Can this row be hidden
automatically?

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄