Macro to create unique id from email address and assign to repeated entries

Hello, I need help.

I am creating a rollup file from hundreds of excel files each has the same structure

Each file will have a dozens to hundreds of names and some files will share entries i.e Juan Alvarez might be in 10 different files

I need to create a unique numerical identifier starting at 0 for everyone based off there unique email address for each individual in the rollup file

So Juan Alvarez would need to be given the same numerical ID every time he showed up in the rollup


Thanks

Please Login or Register  to view this content.

Rollup
After filtering on "Name"

Please Login or Register  to view this content.

Why create a unique identifier when email address is already one?