mm5680
New Member
- Joined
- Jun 26, 2009
- Messages
- 4
I hope someone can help me with this. Example below:
Name ....... NameID ........ Location....... LocationID
Melissa ..............................Florida
John ..................................New Jersey
Mary ................................ New Jersey
Robyn ...............................California
John ..................................Florida
My goal is to have the NameID column and Location ID column assign a unique id for each name and each location keeping the same names with the same Id and same locations with the same id.
I have tried =IF(COUNTIF($F$2:F2,F2)=1,MAX(LocationID:LocationID,0)+1,INDEX(LocationID:LocationID,MATCH(F2,Location:Location,0),1))
but it regenerates new ID's whenever I save the document or open it again. Also, it creates Id's in the hundreds and keeps going up, now I have Id's that are in the 7000's. I need this to work in such a way that if I change Melissa's location to New Jersey it will know to assign her the New Jersey ID.
Thanks,
Missy
Name ....... NameID ........ Location....... LocationID
Melissa ..............................Florida
John ..................................New Jersey
Mary ................................ New Jersey
Robyn ...............................California
John ..................................Florida
My goal is to have the NameID column and Location ID column assign a unique id for each name and each location keeping the same names with the same Id and same locations with the same id.
I have tried =IF(COUNTIF($F$2:F2,F2)=1,MAX(LocationID:LocationID,0)+1,INDEX(LocationID:LocationID,MATCH(F2,Location:Location,0),1))
but it regenerates new ID's whenever I save the document or open it again. Also, it creates Id's in the hundreds and keeps going up, now I have Id's that are in the 7000's. I need this to work in such a way that if I change Melissa's location to New Jersey it will know to assign her the New Jersey ID.
Thanks,
Missy
Last edited by a moderator: