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

1. ## 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. ## 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. ## 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. ## 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. ## 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. ## Re: Create Unique ID # for ALOT of Data

Compared to what I did, what SHOULD it be?