data valiadation

Hi Team, I am working on a request where an excel sheet has few columns with columns format like(SSN , ZIP code and YYYYMMDD format) data. Now on the same sheet there is a button. If I click on that button, then all the sheet data will be exported to a new excel sheet and that will be saved into...

Hey guys. I have a problem with data validation. I'm trying to learn how to make custom validations, but It´s been hard, so I'm here to ask your help. So, I need to turn this in to some data validation: OR(F9="ESolteiro";AND(F9="ECasado";G9=1) -> allow between 0 and 3 AND(F9="ECasado";G9=2)...

Hello, Under the plan tab, I have column G, where I am using data validation list. The drop down list will have over 15 items and I can only select 1 out of 15. However, I want the option of selecting multiple items, how can i do that? Any help will be highly appreciated. Kind regards, Amit...

Hi everyone, Here's my problem. The objective is for people to only be able to touch a cell if a condition is met and they have to select from a list. Example: people using this excel will only be able to write in cell C2 and choose from a drop-down if B2 = "lalala". I thought about doing it...

Cordial greetings I have two concerns and they are as follows. The first one is, in column A are registered 6 States with their respective cities, the name of each State is in capital letters, now, I need to extract in a separate column (can be for example column L) only the names...

Hello cordial greetings I am new, I hope I am not making a mistake at the time of posting. I am a bit confused, I need to perform a data validation in cell C7, so that the days correspond to the month set in cell C6 and the year found in cell C8. The data is recorded in the DATA tab; I have...

i used following formula to extract unique values from a list- =IFERROR(INDEX(Table_AMIS[UPLIFTDATE],MATCH(0,INDEX(COUNTIF($AH$1:AH1,Table_AMIS[UPLIFTDATE]),),0)),"") Now in order to create a drop down list from the above distinct list i put the following formula in data validation field...

Hello, I am trying to compile a simple list of select student/ class scores derived from a master sheet that contains all the scores of all the students. So, the master sheet would contain the Following headers starting from Cell A1 - Student Name, Subject, Exam 1, Exam 2, Exam 3, Final...

Hello again, helpful Excel-masters Because of this Corona-thing going around all of our employees have been asked to work form home for the foreseeable future. One issue we have is that we have to limit how many employees are on break at any given time, which is easily done when they're all in...

I'm trying to create a form, but I'm facing some challenges. Registration Number should start with an R and have max of 13 characters e.g R1234567891234. I was able to use custom data validation =EXACT(LEFT(D5,2), "R-") to enforce it starting with R but not for character length. Then I want...

I have a table in which currency in A and values in B <tbody> CAD 2 USD 13 AUD 15 CAD 5 CAD 11 </tbody> I enter text CAD in C1 and make data validation list in D1. Based on text in C1 data validation only shows the value against CAD. like image attached.

I want to make a dynamic DATA validation list that changes the list every time a cell changes it value, i.e. if A1="category" then make the drop down list tag name "categories," if A1="month" then make the drop down list tag name "months" etc... here's my formula which works great except for the...

Hi Excel gurus! I was just wondering if there's a way of highlighting cells that contain data validation? I have a spreadsheet that has random data validations across each row, I was wondering if it's at all possible to highlight these cells (that contain a data validation drop down) in yellow...

Hi, I am trying to create a custom data validation and I need some help with the formula syntax. In my spreadsheet Column B has a drop down that says "Refund" and "Charge". I want to create the custom data validation in Column D to limit the number of characters in the cell so that any line...

Hello All, Thank you for viewing this message, I hope you can find a better solution for this issue. Background: I have to create a schedule that has a data validation list for a specific jobs. My spreadsheet is divided into 3 tabs. The first is a list called Crews that will break out all...

Hi I am trying to figure out how to make this work. In column "F" starting at row 5 the managers enter a sale price for an item. In Column "I" I have a formula that is put in by a macro that will tell them the % of discount they are giving. they click on a button and the macro runs and pull a...

Hello I defined a name range for certain values & using the named range in Data validation. So that I can enter only those values which are associated with that value. I have Two sheets DATA & RAW DATA In RAW DATA sheet in Column B & C I am entering values manually which are linked with...

Hello, I am trying to create a dropdown list of options with data validation, but combining strings and cell references as follows: Data Validation Source: "ALL",B2:B8,"Other" Unfortunately this just gives me a dropdown list with the following options: "ALL" B2:B8 (with "B2:B8" given...

I would like to only allow the user to enter a date in the inputbox in the format of 'mm-dd-yyyy'. If they do not I want to send msgbox. Here is what I have, just am unsure of how to get the validation. Sub Populate_Date()On Error GoTo NotValidInput Dim myvalue As Date myvalue = InputBox("Enter...

Hello All, I have UTFSE however i really am having difficulty explaining this issue so please bear with me. I have a list of products and its used for Data Validation, the idea is i can just select the product name, the next step is to be offered a list that will only show me the relevant...