[SOLVED] IF statement within Data validation - Excel Help Forum
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 …
Data Validation won't accept this formula, WHY??? [SOLVED]
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 …
How to increase characters limits from 255 in data validation …
Jun 1, 2015 · Re: How to increase characters limits from 255 in data validation formulas, Prepare a list in excel and create a named range by using name manager and use that in data …
[SOLVED] IF AND / OR Statement for Data Validation rules
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 …
Date/Time data validation [SOLVED] - Excel Help Forum
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 …
Formula works but not for data validation [SOLVED]
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. …
Data Validation List with Unique & Xlookup in "Source" [SOLVED]
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 …
Filter from data validation list that includes "All" [SOLVED]
Jun 3, 2025 · I created a filter that works based on a data validation list. I realized I also wanted to option to view "all" so I updated the data validation list to include this option but I am unsure …
Combine two data validation functions - 'List' & 'Custom'
Sep 25, 2018 · Hi All, Using data validation, I know it is possible to do the below separately: 1. Create a data validation drop down list (ALT + A + V + V then select list from the 'Allow' field …
data validation (dates or N/A) - Excel Help Forum
Oct 23, 2020 · Re: data validation (dates or N/A) Thanks for the help, I had tried something similar to this. But wasn't sure if it was possible to do it without overwriting the formula. I want it so …