|
|
#1
10-30-2011, 06:01 PM
|
|||
|
|||
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 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Name - Display Name
|
Jamal NUMAN | Outlook | 2 | 11-21-2010 09:52 PM |
| Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |
| Display the cells which add up to a certain sum | edbyford | Excel | 1 | 11-26-2009 01:30 PM |
| Display names | Ineedhelp | Outlook | 1 | 05-12-2009 11:28 PM |
| Shapes Will Not Display | JoeTx | Visio | 0 | 03-13-2008 09:01 AM |
Windows XP 
Office 97
Threaded Mode