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.