Guys....listen up...I dunno whether ya come across such a situation...but 'if'....then try this...
excel column A
A
1 Fool
2 Prodigy
3 Brilliant
4 Exemplary
5 Fool
6 Fool
7 Prodigy
8 Fool

ya got yourselves an excel column with duplicates..if ya wanna find those duplicates n suffix them with numbers or alpha.....to make 'em unique..this may helpya...

im gonna place a formula in B1......=if((countif($A$1:A1,A1))=1,A1,A1&" "&countif($A$1:A1,A1)) drag down..
ya'l get somethin like this.....in column B

B
1 Fool
2 Prodigy
3 Brilliant
4 Exemplary
5 Fool2
6 Fool3
7 Prodigy2
8 Fool4

Hey guys...im not a pro or computer genius...just tried to make this up for my work...just tell me if this is some kinda bull crap......