Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data Validation List
HI Experts,
A B C D 101 ABC NO In D column i have a data validation i'e if c1="No", "NA", count(A1, B1)=2 and D2=DATE(2013,1,1),D2<=DATE(2014,12,31) when i am selecting C1 as "No", not automatically populates "NA" in column. In the data validation i use the following custom foruma =IF(C2="YES",AND(COUNTA(A2,B2,C2)=3,D2=DATE(2013 ,1,1),D2<=DATE(2014,12,31)),"NO") pLEASE HELP ME THanks, Murugavel S |
#2
|
|||
|
|||
Quote:
where is the date for this? You are checking column D for a date in 2013 or 2014 - the date is not in your example. also why are you checkin if count(a2, b2, c2) =3? Last edited by shanermuls : February 23rd 13 at 05:11 PM |
#3
|
|||
|
|||
HI,
In column C2 has dropdowlist as "Yes" or "No". when i am selecting "No" in the cell C2, the D2 cell populates the value "Na". But I am selecting "Yes" in column C2, it allows the date conditon between 2013 - 2014 and the check the values A2 and B2 are enetered. Hope you are clear now. Thanks, Murugavel S |
#4
|
|||
|
|||
Quote:
And also did the example help? Last edited by shanermuls : February 23rd 13 at 05:55 PM Reason: additional question |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation - Validation list is larger than the cell width | Excel Programming | |||
Use VBA to reset data validation (=list) value to first value in that list (list is a named range) | Excel Programming | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Programming |