LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide values in a Drop Down list [email protected] Excel Discussion (Misc queries) 1 August 24th 08 07:02 AM
hide drop down list Julie Excel Discussion (Misc queries) 1 July 29th 08 03:15 AM
How do i set up a drop down list and hide my list data. Bill Excel Worksheet Functions 1 January 26th 07 12:38 PM
Hide Duplicates in a Drop Down List Sloth Excel Discussion (Misc queries) 1 January 5th 06 02:23 AM
Use list options to hide columns G_Chem Excel Discussion (Misc queries) 5 June 25th 05 06:05 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"