#1   Report Post  
Junior Member
 
Posts: 3
Default 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   Report Post  
Junior Member
 
Posts: 20
Default

Quote:
Originally Posted by murugavelmsc View Post
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
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?
Attached Files
File Type: zip Example.zip (6.3 KB, 41 views)

Last edited by shanermuls : February 23rd 13 at 05:11 PM
  #3   Report Post  
Junior Member
 
Posts: 3
Default

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 View Post
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?
  #4   Report Post  
Junior Member
 
Posts: 20
Default

Quote:
Originally Posted by murugavelmsc View Post
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
Okay - but where is the date entered?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation - Validation list is larger than the cell width Barb Reinhardt Excel Programming 1 March 4th 10 09:24 PM
Use VBA to reset data validation (=list) value to first value in that list (list is a named range) ker_01 Excel Programming 7 October 27th 08 04:13 PM
data validation invalid in dynamic validation list ilia Excel Discussion (Misc queries) 0 November 7th 06 01:54 PM
data validation invalid in dynamic validation list ilia Excel Worksheet Functions 0 November 7th 06 01:54 PM
data validation invalid in dynamic validation list ilia Excel Programming 0 November 7th 06 01:54 PM


All times are GMT +1. The time now is 05:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"