Unique data ranking of duplicate data

[noobiexcel]

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.

[nimrod]

Place this formula in empty column in Row 2 and then copy down

=IF(COUNTIF(A:A,A2)=1,"Unique",COUNTIF(A:A,A2)-COUNTIF(A2:A20000,A2)+1)

[canapone]

Hi,

more or less same Nimrod's approach:

Please Login or Register  to view this content.

could do the trick.


Regards

[nimrod]

Thanks canapone , I like yours over mine . I like the elegance of yours. Cheers

[noobiexcel]

OMG! this is amazing. hahaha. im just learning how to do excel. Thank you so much