| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide formula in list
Hi,
I´ve made a list i Data Verifying that should display the options 0 or 1. 0 just being the digit 0 and 1 being the formula =SUM(D3)+1. How to I get 1 as an option in the list and avoid having to show the formula in the list? Thanks in advance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hide formula in list
I meant Data Validation, not Verifying. Just to clarify.
"Errko" skrev: Hi, I´ve made a list i Data Verifying that should display the options 0 or 1. 0 just being the digit 0 and 1 being the formula =SUM(D3)+1. How to I get 1 as an option in the list and avoid having to show the formula in the list? Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide values in a Drop Down list | Excel Discussion (Misc queries) | |||
| hide drop down list | Excel Discussion (Misc queries) | |||
| How do i set up a drop down list and hide my list data. | Excel Worksheet Functions | |||
| Hide Duplicates in a Drop Down List | Excel Discussion (Misc queries) | |||
| Use list options to hide columns | Excel Discussion (Misc queries) | |||
Linear Mode
