Macro to create and associate unique numerical id with unique email ID

[Tim Hanson]

Hello,

I have a file with two columns: name and email and thousands of rows,the emails addresses provide a unique id field.

I need a macro to creates a unique numerical ID starting at zero and continuing to last row such that it looks like the Final Structure.

Any help with this is greatly appreciated, I do not know where to begin with this.

Thanks

flie

[CODE]Name        email          
Bob Johnson  bobjohnson@email.com   
Bob Johnson  bobjohnson@email.com  
Frank Carpet frakkcarpet@email.com  
.              .
.              .
.              .
Juan Alvarez Juanalvarez@email.com   
Juan Alvarez Juanalvarez@email.com
Juan Alvarez Juanalvarez@email.com 
Joe Jenson   joejenson@email.com     
sally Berg   sallyberg@email.com 
.                .
.                .
.                .
Polly Pots     polly pots@email.com 
Yara Flowers  yaraflowers@email.com    
Yara Flowers  yaraflowers@email.com 
Yara Flowers  yaraflowers@email.com
Yara Flowers  yaraflowers@email.com 
Yara Flowers  yaraflowers@email.com

Final Structure

Name         email                    ID
Bob Johnson  bobjohnson@email.com     0
Bob Johnson  bobjohnson@email.com     0
Frank Carpet frakkcarpet@email.com    1
.              .
.              .
.              .
Juan Alvarez Juanalvarez@email.com    17
Juan Alvarez Juanalvarez@email.com    17
Juan Alvarez Juanalvarez@email.com    17
Joe Jenson   joejenson@email.com      18
sally Berg    sallyberg@email.com     19
.                .
.                .
.                .
Polly Pots   polly pots@email.com      2552 
Yara Flowers  yaraflowers@email.com     2553
Yara Flowers  yaraflowers@email.com     2553
Yara Flowers  yaraflowers@email.com     2553
Yara Flowers  yaraflowers@email.com     2553
Yara Flowers  yaraflowers@email.com     2553

 

[Hui]

Why not add a column C
C1: ID
C2: 0
C3: =IF(B2<>B3,C2+1,C2)
Copy C3 down

 

[Tim Hanson]

Hui, Thank you!!!, that turned out to be way easier then I thought.