Data Validation List

[murugavelmsc]

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" i
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

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[shanermuls]

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" i
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

Example attached - changed "NO" to "NA"

where is the date for this? You are checking column D for a date in 201
or 2014 - the date is not in your example.

also why are you checkin if count(a2, b2, c2) >=3

+-------------------------------------------------------------------
|Filename: Example.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=772
+-------------------------------------------------------------------