ExcelBanter - Hide formula in list

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Hide formula in list (https://www.excelbanter.com/excel-worksheet-functions/259272-hide-formula-list.html)

Errko

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.

Errko

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.

All times are GMT +1. The time now is 09:53 AM.