Create Unique ID # for ALOT of Data
Results 1 to 6 of 6

Thread: Create Unique ID # for ALOT of Data
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2019
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Create Unique ID # for ALOT of Data

    Hello,

    Have been struggling with this for some time.

    Basically- we have land owners who own multiple properties across different counties.

    I may not uncover all of what one land owner owns - and so assigning a unique ID # to them proves difficult.

    I need to assign each individual NAME with an ID #.

    I then wish to create a unique PROPERTY ID - that will incorporate the above NAME ID #.

    So all together I need:

    one ID # for the Individual Owner

    one ID # for the properties (that incorporates the Individual Owner ID #)

    I then need a method to check NEW lists for EXISTING owners.

    Any help is appreciated. It has been a nightmare!

  2. #2
    Board Regular kweaver's Avatar
    Join Date
    May 2018
    Location
    La Jolla, CA
    Posts
    600
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Create Unique ID # for ALOT of Data

    Just a thought, if I understand part of the issue, to consider.
    If you have the names (with duplicates) in column A (A1 header), and you create an initial ID for the first person (e.g., 1000) in B2, then this formula in B3 (and fill down) will retain the ID for that person and increment IDs for the others.

    Code:
    =IF(ISNA(MATCH(A3,A2:$A$2,0)),MAX(B2:$B$2)+1,VLOOKUP(A3,A2:$B$2,2,FALSE))
    Any help?

  3. #3
    New Member
    Join Date
    Jul 2019
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Create Unique ID # for ALOT of Data

    Yes that helped solving the Unique ID problem for the owners.

    Now I need to create an ID for the individual properties they own. Basically:

    "Owner 1" owns in towns "X,Y,Z"

    I need an ID for each "X", "Y", "Z" that also includes the "Owner 1" ID.

    "Owner 1-X"

    "Owner 1-Y"

    "Owner 1 -Z"

    Something like this.

  4. #4
    Board Regular kweaver's Avatar
    Join Date
    May 2018
    Location
    La Jolla, CA
    Posts
    600
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Create Unique ID # for ALOT of Data

    Is this over-simplifying it?

    Excel 2010
    ABCD
    1NamesUnique IDPropertyBy Owner ID
    2Owner 11000Property XOwner 1-1000-Property X
    3Owner 21001Property AOwner 2-1001-Property A
    4Owner 31002Property WOwner 3-1002-Property W
    5Owner 11000Property YOwner 1-1000-Property Y
    6Owner 31002Property VOwner 3-1002-Property V
    7Owner 21001Property BOwner 2-1001-Property B
    8Owner 51003Properdy DOwner 5-1003-Properdy D
    9Owner 21001Property COwner 2-1001-Property C
    10Owner 51003Property EOwner 5-1003-Property E
    11Owner 61004Property POwner 6-1004-Property P

    Sheet2



    Worksheet Formulas
    CellFormula
    B3=IF(ISNA(MATCH(A3,A2:$A$2,0)),MAX(B2:$B$2)+1,VLOOKUP(A3,A2:$B$2,2,FALSE))
    D2=A2&"-"&B2&"-"&C2


  5. #5
    New Member
    Join Date
    Jul 2019
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Create Unique ID # for ALOT of Data

    Yes and no. I would only use the Unique ID within the Property ID.

    Basically- one owner can own many properties. Each Property needs to be unique - and also contain the singular Owner Unique ID.

  6. #6
    Board Regular kweaver's Avatar
    Join Date
    May 2018
    Location
    La Jolla, CA
    Posts
    600
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Create Unique ID # for ALOT of Data

    Compared to what I did, what SHOULD it be?

Some videos you may like

User Tag List

Tags for this Thread

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
  •