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 …

Apr 29, 2021 · Excel is doing exactly what YOU are telling it to do. There are two option: 1. select the entire column starting with the first data row until the last row + more if more data is to …

Jan 30, 2014 · IF AND / OR Statement for Data Validation rules Hi Everyone - this is my first post and it is a pleasure to now be a part of your community. I am a bit stuck however with a …

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 …

I want to add "data validation" in a cell (which is variable) using VBA and the range which is to come in the data validation list is also variable. Till now I have been using this Here "range1" ...

Jul 18, 2022 · 0 I have a table where I want users to fill values off a list using data validation. The content of the validation list should be based on values entered in two other tables which are …

Dec 22, 2020 · However, one of my colleagues changed the data validation parameters to allow the sheet to accept the lower value. Is it possible to lock the data validation so people can't …

Apr 8, 2025 · 0 So let say I have two sheets in Excel, one of them is a database table from where I pull data and the other one is a new sheet on which I construct a new table. All good until I …

May 25, 2024 · Expected result 1: Data validation in D6 with list of unique values from column A - this works Expected result 2: Data validation in D17 with list of values from column B where …