Unique ID For Email Addresses

[Ravey]

Hello,

I have about 6 Excel files full or email address.
160K rows.

The list looks like this:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]date[/TD]
[TD]Order[/TD]
[TD]Sale[/TD]
[TD]Email[/TD]
[TD]I NEED UNIQUE ID[/TD]
[/TR]
[TR]
[TD]1/2/2008[/TD]
[TD]1[/TD]
[TD]$2[/TD]
[TD]j@j.com[/TD]
[TD]2234[/TD]
[/TR]
[TR]
[TD]1/2/2008[/TD]
[TD]2[/TD]
[TD]$2[/TD]
[TD]wo@.com[/TD]
[TD]2235[/TD]
[/TR]
[TR]
[TD]1/2/2008[/TD]
[TD]3[/TD]
[TD]$2[/TD]
[TD]j@j.com[/TD]
[TD]2234[/TD]
[/TR]
[TR]
[TD]1/2/2008[/TD]
[TD]4[/TD]
[TD]$2[/TD]
[TD]sam@cool.com[/TD]
[TD]2236[/TD]
[/TR]
</tbody>[/TABLE]

 

[Scott Huish]

=2233+ROWS($A$1:A1)

Copy down.