[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 the DV list is …
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 references instead.
[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 redacted the text …
How to increase characters limits from 255 in data validation formulas,
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 validation Samba Say …
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 searched the …
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. So I created a …
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 and denote the …
Data Validation Source=INDIRECT errors [SOLVED]
Jan 13, 2020 · Re: Data Validation Source=INDIRECT errors You can use formula in a name and this name in the data validation. Bat why J2 or it is only example?
Creating a dynamic table that filters based on multiple data validation ...
Feb 25, 2025 · Re: Creating a dynamic table that filters based on multiple data validation filters Thank you for the reply - although I'm seeing that the result returned isn't correct. Cell C12 (the yellow cell) …
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 source.