Results 1 to 5 of 5

Validating a Data Entry ...

This is a discussion on Validating a Data Entry ... within the Excel Questions forums, part of the Question Forums category; Hi, Say, Cell A3, has Code with a drop down list box. I'm picking the 1st item "cd01". The Code ...

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    4

    Default

    Hi,

    Say, Cell A3, has Code with a drop down list box. I'm picking the 1st item "cd01". The Code Name is displayed in B3. C3 has division, which is again a drop down list box. I'm picking "APD".

    Next entry by mistake if I happen to select cd01 and APD again, I must display an error message.

    Hope you must have understood my problem.


    I'm getting problem with your edit option. It's not allowing me to edit, so I'm re-entering this question again.

    Regards.

    Rams



  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,947

    Default

    I think, not sure, that you could use Data Validation for this, with a formula, something like

    =COUNTIF(A$1:A1,A1)=1

    For the "Edit" part... I believe it only allows you to edit it for the next 30 minutes after you have posted.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    Board Regular sen_edp's Avatar
    Join Date
    Mar 2002
    Location
    Hellas
    Posts
    554

    Default

    Hello Rams
    go to the following link

    http://support.microsoft.com/support.../Q213/1/85.ASP

    Andreas

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    4

    Default

    Hi,

    I don't need the count of it. I want to avoid the redundancy of records being entered. It's just a way of entering unique records.

    How will I display the error message for this ?


    Regards.

    Rams.



  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    4

    Default

    Dear Sen_edp,

    Thank you very much for the link that you provided to me. I'm currently working on it. If I'm successful in it, I'll inform you.

    Regards.

    Rams.



Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com