Apr 6, 2022 · Re: Data Validation won't accept this formula, WHY??? You cannot use table structured references in a data validation formula. You will have to use the actual row/column …

Sep 18, 2023 · Re: IF statement within Data validation Post #2 is your best compromise. If you put a formula in the cell and then apply data validation to it, the formula will only execute until …

Sep 17, 2024 · Re: Formula works but not for data validation Unfortunately the FILTER function can't be used in a data validation formula. I tried a named formula but it didn't like that either. …

Jan 30, 2014 · Re: IF AND / OR Statement for Data Validation rules Hi benishiryo - I visited your fine city recently and had a wonderful time (our regional office is located there...) Yes I …

Oct 18, 2023 · Re: Data Validation List with Unique & Xlookup in "Source" Place the good formula on another worksheet (say on Sheet 3 in A1), then use =Sheet3!A1# for the data validation …

Sep 4, 2012 · Data Validation (List) too long I am trying to create a drop down list that see's the entry to left of it and brings down the appropriate list. My code is as follows:

Feb 19, 2024 · I am creating a dependent drop down where the drop down itself is located on the first tab of the sheet and the data that includes the dropdown options is on another tab.

Jun 20, 2017 · Re: Data validation to allow blank cells with formula I dont think this solves the problem but this looks better to me regarding B2 =AND (LEN (B2)<>0,ISNUMBER (C2)) …

Dec 29, 2023 · I have been trying to assemble a formula for use in data validation that ensures a date and time is entered (obviously there is a native function for date and time separately). I …

Jan 12, 2019 · Re: Data Validation with IF Formula + list Changing the validation source for B4 to =IF (C4=1,Deadlines) Will do what you need. Remember to check the box to apply the …