data validation condition

  1. O

    Data Validation to only include certain date dependant rows from a dataset

    Hi, using my example screenshot, I need to create Data Validation to show a list only of those items in column P where the date in column Q is today or in the future. So in this example I would only want to see the column P items numbered 5,7 and 8 as they're future dates (based on today's date...
  2. B

    Data validation with condition

    Hello, I'm trying to do something that i'm honestly not confident that can work as I imagine. Lets assume that I have cell A1, where I can have "Sunday" or "Weekday" In cell C1, tha data will depend on what is in cell A1, So, if I have "Sunday" in cell A1, I want cell C1 to be empty, but if...
  3. M

    Set Character limit based on another cell contents

    Hi. I sure hope this is an easy one, but I can't seem to find the answer anywhere. I have a template that lists addresses and need to make sure that when the country is United States, the Zip Code has 5 digits since state zips with leading zeros are always being dropped. Is there any way to do...
  4. K

    Data validation: Conditional response setup not flagging errors

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

    DATA VALIDATION LIST | INDIRECT | VLOOKUP

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

    double data validation

    Hello, In Cell AR2 I want the person to put only the letter "W", this I achieved through data validation However I also want that the person cannot put anything if there is any value in cell AG2 Can anyone please help me in this, thanks in advance
  7. R

    Data Validation with 2 different if statements

    I am creating a system for Product log which has 3 sheets. 1st sheet is Batch card register which contains batch no. and quantity. 2nd sheet contains product log_In where input for dispatch, rejection and product -In is entered. 3rd sheet is a FG REGISTER which has list of rejection, dispatch...
  8. A

    Data validation for showing error

    In F5 ,I have a List. if any one select this values "Book1","Book2" and "Book3".. i have to show some error using data validation "=OR((F5<>"Book1"),(F5<>"Book2"),(F5<>"Book3"))" why this code is not working??
  9. E

    Data Validation

    I am trying to get some data validation to work based on if a certain value is entered to not allow it and notify user. I see all the options are to compare to “allowed values” but I would like to prompt user and not allow just the letter C to be entered in some ranges of cells. How would one go...
  10. W

    Validate Data on the back end

    We have in our stores a purchase order field. Unfortunately there is no data validation system in place and users can type whatever they want , so we end up with addresses and street names spelled slightly differently all over the place, making job summaries via downloaded excel files a pita...
  11. R

    Compiler Error | Sub or Function not defined

    Hi All, I am new to the Excel VBA. I am using the below code snippet to validate the excel data set but getting Compiler Error | Sub or Function not defined. Could someone guide me on this issue: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _ Cancel As Boolean)...
  12. C

    IFS statement with Data Validation

    Hello, I am trying to make an ifs statement that works with data validation. I want it to be IFS(A1="Location1","Fred",A1="Location2","Mike",A1="Location3", *drop down of 3 names*) (If A1= Location 1 then A2 autopopulates to Fred, same with location 2 and Mike, Location 3 I want a drop down of...
  13. S

    Formulas in List of Data Validation

    Hi All, I'm struggling to use a formula in the "List" area of Data Validation. I will have sheets 1 to n, within my workbook, and each sheet has its sheet ID in cell A1. I have a lookup sheet, with all the possible values I want to use in my data validation. Each sheet will require a...
  14. E

    Pop Up message when value is changed - dependent on other conditions

    My data starts in row 2. Column AA is validated for Y,N,N/A values only, column ABcontains N/A or a date, and column AD can contain N/A or a date. All columns will initially be ‘N/A’ but there is apossibility that this will change, is there any formula that will bring up apop-up message if AD...
  15. S

    Allowed to manually enter data in cells with data validation on

    I have a workbook with data validation throughout, some time ago I unchecked the Show error alert after invalid data is entered, recently I changed it back however it still lets me manually type in stuff even though the data validation for a list is turned on, anyone got any ideas here? thanks...
  16. R

    Data Validation Box Pops Up when cell meets certain criteria

    Right now I have cell E4 filled with: =IF(D4='Training Data'!$A$2,'Training Data'!$B$2,IF(D4='Training Data'!$A$3,'Training Data'!$B$3,IF(D4='Training Data'!$A$4,'Training Data'!$B$4,IF(D4='Training Data'!$A$5,'Training Data'!$B$5,IF(D4='Training Data'!$A$6,'Training Data'!$B$6,IF(D4='Training...
  17. C

    Dynamic Data Validation List Based on Another Column

    Any ideas on a non-VBA option to have a data-validated dropdown list on Sheet 1 be dynamic, using the value in a neighboring column in Sheet 1 to then lookup the dropdown list values from sheet 2? I really appreciate any ideas! Sheet 1 I will populate the values in the Main Category column and...
  18. S

    Custom data validation formula

    Hi everyone! I am currently working on a spreadsheet and I am facing some difficulties in regards to custom data validation. Basically i have a column which contains consecutive numbers, i.e. cell G9 contains 126, G10= 127, G11= 128, G12= 129....etc... so what i would like to do is.. when...
  19. J

    Custom data validation not working the way I need it to.

    Cell C19 and cell E19 represent "yes" and "no" respectively. I want users to answer the yes or no question by entering an "x" in either C19 (for "yes") or E19 (for "no"). According to my understanding of custom data validation, this formula for C19 below should work. But it continues to allow...
  20. S

    Vlookup in data validation

    Hello, <tbody> Salesperson Customer Name Person A Customer1 Person A Customer2 Person A Customer3 Person B Customer4 Person B Customer5 </tbody> I have the above master data and I need to use data validation to get the list of customers in a drop down associated for a particular...

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