| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide all values in a row if value is 0
I am putting together a forecast sheet for part requirements and with so many
parts to deal with I would like to set it up so that anytime the required amount is 0, then the entire row is hidden. Currently I have a simple formula to just show a blank cell. It is time consuming to review 300 P/N when I may only need 14 P/N that week. How can I go about hidding the entire row in a formula? Thank you, Erik |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
| View of x-axis values | Charts and Charting in Excel | |||
| How do I hide 0 values in line charts | Charts and Charting in Excel | |||
| Excel - hide erroer values | Excel Discussion (Misc queries) | |||
Threaded Mode
