Results 1 to 3 of 3

Thread: Excel help

  1. #1
    Join Date
    Nov 2009

    Unanswered: Excel help

    Hi experts

    i need a small help or guidance

    in excel , i want the system to restrict duplicate entry for a column

    if suppose , if i try to enter value 100 anywhere in column a for the second time, it should the accept the same value for the 2nd time and and intimate the no already exists and try a new one

    is it possible, if it so , kindly guide me how to do that

    a little urgent pls


    r sudhaakar

  2. #2
    Join Date
    Sep 2008
    London, UK

    Yes, it is possible using data validation. Here is an example in Excel 2003.

    • Select the whole of column F.
    • Data > Validation > Settings Tab
    • In the 'Allow' Dropdown box choose 'Custom'
    • In the 'Formula' box type in =COUNTIF($F:$F,$F1)<=1
    • On the Error Alert tab type in your customised message
    • OK

    Now duplicate entries will not be allowed within column F.

  3. #3
    Join Date
    Feb 2011
    Miami, Florida
    Yes, with the help of Data Validation in Excel you can create a validation for an alert of having duplicates...

    Data validation is a tool that helps you control the kind of information that is entered in your worksheet. With data validation, you can:

    --provide users with a list of choices
    --restrict entries to a specific type or size
    --create custom settings

    You can use Data Validation to create a dropdown list of options in a cell. List items can be typed in a row or column on a worksheet, or typed directly into the Data Validation dialog box. Then follow the steps for creating validation..
    1. In single row or column, type the entries you want to see in the drop-down list. (Note: The list must be in a single block of cells )
    2. Name the List Range
    3. Apply the Data Validation by Selecting the cells in which you want to apply data validation.Then from the Data menu, choose Validation. From the Allow drop-down list, choose List. In the Source box, type an equal sign and the list name. Now click OK

    You can also Use a Delimited List:- Instead of referring to a list of items on the worksheet, you can type the list in the Source box, separated by commas.

    If you want to allow users to type items that are not in the list., turn off the Error Alert.

    Hope now you finally understand the way for validating cells.

    Thanks & regards

Posting Permissions

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