Results 1 to 4 of 4

Thread: Data Validation List

  1. #1

    Data Validation List

    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.


    Murugavel S
    Attached Files Attached Files

  2. #2
    Cross posting here in Excel Forum

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

  3. #3

  4. #4
    Thanks BOB!

    . Array(CSE) { }, formulae are confirmed with CONTROL+SHIFT+ENTER.

    . -Replace commas ( , ) with semicolons ( ; )-or vice versa in formulae, if your locale setting demands.

    .--Don't attach a screenshot--Just attach your Excel file!

    .--KISS(Keep it simple Stupid)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts