data valiadation

  1. T

    Making a cell mandatory to fill before being able to fill in another cell with a drop-down

    Hi, I have the following table: Car Name Colour Car_021 Red Car_022 Grey Car_023 Blue Car name is a specific name. And colour is a drop down list. I'm trying to add a data validation to the colour column so that before a colour option can be selected the car name must not be...
  2. N

    Exported excel sheet data validation

    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...
  3. B

    Data validation with conditions

    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)...
  4. A

    Multiple selection from drop down list

    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...
  5. G

    Drop-Down and IF Statement Data Validation in one cell

    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...
  6. Q

    Conditional data validation drop-down lists

    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...
  7. Q

    Confusion with data validation (list)

    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...
  8. S

    Error in Data Validation List using Offset Function in Excel || (the source currently evaluates to an error)

    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...
  9. S

    Help with duplicates on Excel 2019 - Mac

    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...
  10. M

    Data validation, formula difficulties

    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...
  11. S

    Data Validation Problem

    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...
  12. A

    Data Validation List based on Cell Value

    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.
  13. L

    Dynamic DATA validation list

    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...
  14. E

    Highlight cells that contain data validation

    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...
  15. J

    Custom Data Validation Help

    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...
  16. P

    Creating Dynamic Ranges For Data Validation

    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...
  17. J

    pop up box if cell >90%

    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...
  18. J

    Excel Help in relating to Name manager Data validation Match & Indirect for restricting entering wrong values.

    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...
  19. K

    Mixed reference/string options in Data Validation dropdown list?

    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...
  20. J

    Data Validation on InputBox

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top