+ Reply to Thread
Results 1 to 5 of 5

No duplicate numbers in a worksheet.

  1. #1
    Registered User
    Join Date
    07-23-2007
    Posts
    3

    No duplicate numbers in a worksheet.

    I run a trailer log through a worksheet and sometimes the same trailer number gets entered in two different locations. Is there a way to stop letting people enter the same number twice on a spreadsheet?

  2. #2
    Registered User
    Join Date
    07-23-2007
    Posts
    3

    duplicate numbers

    I am using excel 2003 if that makes a difference.

  3. #3
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    This is dependent on what cells you want to prevent duplicates in. Lets say the range is cells A1:A50. Follow these steps:

    1. Click on Cell A1 and drag down to A50, highlighting the range.
    2. Go to DATA in the main menu toolbar, then select VALIDATION.
    3. Note the allow: dropdown box. Select CUSTOM.
    4. In the formula toolbar, enter this formula: =COUNTIF($A$1:$A$50,A1)=1

    Now, if someone tries enterring the same number in two separate cells, an error message will appear.

    Try it and let me know if it works.

  4. #4
    Registered User
    Join Date
    07-23-2007
    Posts
    3

    Thanks

    That worked, thankyou so much for the quick response.

  5. #5
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    Happy to help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1