To find duplicates in a column and suffix them with numbers to make them unique

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......

im gonna place a formula in B1......=if((countif($A$1:A1,A1))=1,A1,A1&" "&countif($A$1:A1,A1)) drag down..

this formula is a solution.....i ve already explained it..and ve even posted a sample result.

Thank you! This actually just helped me identify duplicate invoices in the list of a few tens of thousands, and make them unique before forwarding for upload into a new system.

-kry

What if you want to do it the other way? I have a list of data that I need to get rid of and appears as 3 characters after a hyphen e.g. -xxx. There are 3 or 4 entries of the same thing the only difference being the suffixes. I need to remove all the suffixes but I need to check all the data the rows contain first as i need to do some merging before deleting the extra entries. Any ideas?!