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" in column.

Attached file is for your reference.

pLEASE HELP ME

THanks,
Murugavel S

[Fotis1991]

Cross posting here in Excel Forum

(Not able to add the link-I need 5 posts for this!?)

[Bob Phillips]

I can though http://www.excelforum.com/excel-prog...tion-list.html

[Fotis1991]

Thanks BOB!