Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Unanswered: Column Uniqueness

    Anyone know how to enforce uniqueness in 2 columns (or more) in an Excel worksheet...inda like a primary key?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Maybe Uniqueness is an alien word....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    Sure... so the combination across x number of columns needs to be unique?

    If the user is manually entering into the columns then you can use data validation. If the values are to be calculated by formulas then you could create an autonumbering system.

    If you elaborate a bit on the requirements and confirm your Excel version then I should be able to whip up an example for you?

Posting Permissions

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