Assigning IDs to names - is this possible?

[benyben123]

Hi.
I have a column with names (repeated names by month).
there are about 3700 of them spread over 12 month. so it's about 300 names per month.

is it possible to assign an ID (a number) to specific names?

so let's say - John Smith will have ID 1 (for example), and will always get this ID?

Thanks!

[MarvinP]

Hi Ben,

This seams like an easy VLookup formula where you lookup a name and hang an ID on it from a lookup table.

Supply a sample file and we can show you how this works.

[benyben123]

Thx
I cannot upload the file because I am not allowed to ):

it is simple:


File Name Date Month First Last ID (Fx) First, Last, Capitalized Sum Address 1 Address 2 City (Fx) City, Capitalized State Zip

[MarvinP]

OK,
See my example of VLookup attached...

[FDibbins]

Hopefully martin has what you need, but my read was that you wanted to create unique ID's for each name? Is so, then, if your data is laied out like this, here are 2 different options...

	A	B	C
1		repeat	Unique
2	Name1	1	1
3	name2	2	2
4	name3	3	3
5	name1	1
6	name2	2
7	name4	4	4
8	name6	5	5
9	name3	3

Column B uses this...
=IF(COUNTIF($A$2:A2,A2)>1,VLOOKUP(A2,$A1:B$2,2,0),MAX($B$1:B1)+1)
It repeats numbers from above, if the name is repeated (see name1)

Column C usaes this...
=IF(COUNTIF($A$2:A2,A2)>1,"",MAX($B$1:B1)+1)
This leave a blank if the name has been repeated above

[benyben123]

Thank you so much!!!

Yup, I want repeated IDs. So John Smith will always will always get the same ID number.

If the names are on column G, and the IDs i wish to create are on column F (see pic attached), what should the formula be?
I tried to change to fit my needs, but got confused.

[FDibbins]

I cant open pics (company fire wall and stuff), but try this...
=IF(COUNTIF($G$2:G2,G2)>1,INDEX($F1:F$2,MATCH(G2,$G1:G$2,0)),MAX($F$1:F1)+1)

[benyben123]

Thanks so much !!!!!!!!!!!!!

[FDibbins]

Happy to help and thanks for the feedback