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