Unique data ranking of duplicate data

Good day,

I am trying to create a unique way of ranking duplicate data.

I have this set of data and i want it to tell me if the email is unique and if its not unique i want to rank it in order of appearance with 1 and 2 and will do so for every duplicate entry

Ex

email (on first column)
sasuke.uchiha@yahoo.com
uzumaki.naruto@hotmail.com
uzumaki.naruto@hotmail.com
haruno.sakura@gmail.com
haruno.sakura@gmail.com
haruno.sakura@gmail.com


rank description (on second column)
unique
1
2
1
2
3

I have tried using countif and rank but Im getting really confused.

I have attached the file I am working on with the formula that I'm trying to use.

I am at my wits end so any help will be much appreciated.

Thank you very much minna-san.