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
Quote:
Originally Posted by shanermuls
Example attached - changed "NO" to "NA"
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?
|