I created a sheet that links a quantity column to another sheet within the same workbook (so I can hide the one sheet with confidential information).
The links work but it shows a "0" in every cell that is blank on the confidential sheet. I want to be able to filter by "non blanks" as I have headings that I put a"." in so they show up. Is it possible not to show "0"s?
Tools | Options | Zero Values
Or
=If(MyFormula = 0, "", MyFormula)
or you could try a Custom Format such as:
0.00;-0.00;""
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Thank you - that last one worked!
Ok an issue with this.... some of the cells we want to put a character in so that it shows up in the filter but when we do this, it changes the other column to "#VALUE!" We used to use "0" but now that the linked tab hides the "0s" in order for the link to not show "0s" all the way down the column, we can't use them anymore to show optional items.
Qty Unit Price Extended Price
1 $130 $130
0 $925 $ -
O $25 Value
Can you post a sample of your spreadsheet?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
Reply With Quote
