Thread: [Solved] How to set a no-display value to cells with a no-value link
View Single Post
 
Old 10-30-2011, 06:01 PM
KIM SOLIS KIM SOLIS is offline Windows XP Office 97
Novice
  
Join Date: Sep 2011
Posts: 29
KIM SOLIS is on a distinguished road
Default How to set a no-display value to cells with a no-value link
Hi experts,

In the attached file Query107, my data entries are in sheet1. Then I made a sheet2 linked to sheet1. In sheet2, when i copy-drag the formula downward there appears zero values, and 1/0/1900 that displayed, especially for cells with a no-value linked in sheet1.

How do I hide this zero and 1/0/2011 values when there is a no-value link found in sheet1. As it is, I have to manually delete these no-values rows before printing.

Please advice.

Kim
Last edited by KIM SOLIS; 10-30-2011 at 06:02 PM. Reason: with attachment
Reply With Quote