data validation (list)

I currently have the issue I cannot backspace on the first value in a cell without throwing all other values in the cell off. This seems to happen when the cell only has 2 values - a Stop Alert I’ve called ‘User Error’ (using Data Validation) is not thrown either. I’m trying to standardize...

Hi, I was able to create a a data validation list by using UNIQUE, however, my rows may change whenever I update the template. Can anyone advise how can I change my current formula to consider the rows changes...

I have tried all that I could find on this site. What I am trying to do is Sumif the colums: Column E,Owner, uses dropdown Coumn F is the the amount paid: =IF(E20="Ian","$.50","") Column G,Payment,I want to total all of Column F: I have: =sumproduct(sumif($E2:$E49,"-ian",$F2:$F49)) also have...

Hi All, I struggled a bit with the title - so I'll try to explain more clearly. I have created a Table in Excel, which I intend to share with a selection of users to populate. This will result in a indeterminate number of rows being populated. Each column in my Table (10 columns in total)...

I have received a new spreadsheet with the annual budget for the 22-23 fiscal year. I also have 5 clients, each with an allocated percentage or breakdown of how much the overall budget is to be applied. Example: client 1 will receive 33% of the overall budget. Is there a way I can have a...

Hello everyone, I have the following code which that does not allow the user to paste values in a Data Validation List Column. My problem is that I have columns (without data validation) that have to stay protected, columns With Data Validation List have no locked option from format cell, but...

Hi, I'm trying to create a system that associates a data-validation system to a set of columns. The data validation should be based on different lists of values, depending on the specific column name. Each list of values is contained within different sheets of the workbook. The workbook is...

Hi I have 4 lists and I would like to use data validation selecting from these 4 lists to give me one of 4 possible text outputs as below What is the best way to do this please - do i need to list out all the possible combinations and my desired outcome for each somewhere on the sheet or is...

Hi everyone, I have three columns A, B, and C and I want to filter the rows that pertain to one of the drop-down list selections that I created, what would be the formula for this? For example, I have listed the first, second and third job preferences of a number of people. I would like to...

I'm developing a workbook for Risk Analysis. Currently we have a single list/array with several thousand lines. We want to make it more managable, by splitting it according the different departments. But the Risk Theme and specific Risks are identical for all departments. I've created a...

Hi, I am trying to create a multiple dependent dynamic data validation in multiple rows. I have tried doing it through name table / Indirect Function and it's working only in the first row. In the Second Row (Column 1) when I am selecting different data, in that case in Column 2 its still...

Hi, there are many rows in my worksheet. For all cells in one column of this worksheet, I want that user can enter multiple options from a list. How can that be done? For e.g. I have 10 rows, and each cell from A1 to A10 represents a person. Then, there is a list of items that a person can...

I am trying to set up data validation for a report, but two columns aren't flagging blank cells they it should. The "Blank" list is the title and one blank cell below it. The AcceptReason has four selections below the title, and the RejectReason has ten. Column I has data validation for...

Hi All, I have tried option to use validations list using Indirect/Vlookup, and its seems no results in Vlookup using. Source - Entry Table UniqueErrorField ErrorField ErrorsNoted Age Age TOP BOX - Wrong Age APS Date Range APS Date Range TOP BOX - Wrong Entry BP History APS Date Range...

Hi everyone So I posted in here a few weeks ago and someone wrote me an excellent VBA which cuts and pastes rows to different sheets depending on what's written in column F of my workbook. The code is as follows: Sub sort_my_data() 'VBA written by SQUIDD from MrExcel.com...

Hi all, I'm simply looking for some clarity on how the Ignore Blanks option works within Data Validation. It was always my belief that unticking this would prevent the user from leaving the relevant cell blank. For instance, if the user deleted the contents of a validated cell but did not...

Forgive me if this has been answered somewhere; I've looked and can't seem to find a solution on the board. I'm using dependent dropdowns in Sheet 1 [Main] via an indirect() in Data Validation from named ranges in Sheet 2 [DVS]. So, you choose the "Parent_Choice1" in Cell A...and then... Cell...

Hi all! I am running multiple offset functions with nested ifs to return a drop down list dependant on 3 variables (A,B,C). Is there a way I can avoid the character limit for data validation? I don't know how I can simplify this formula. Variabe A = Ability Level (0,1,2,3) (Purple) B3 Variable...

Experts, I have exhausted my search for a good solution that combines my three needs. Please help. I'm using a Data Validation List. I want to be able to do three things: 1) Start typing just ONE letter in a cell and the drop down window opens for me to make a choice. For example: Type...

Hello I have the following Data Validation formula that creates a dependent list dropdown. It's complicated because it's designed to remove blank spaces. =OFFSET(Backup!$AK$1,1,MATCH($C$9,Backup!$AK$1:$EC$1,0)-1,COUNTIF(OFFSET(Backup!$AK$1,1,MATCH($C$9,Backup!$AK$1:$EC$1,0)-1,100,1),"?*"),1)...