Assumed is that the data starts in cell A1 and that your example had a typo
where the output example should have had HIJ/HIJ1 instead of HIJ1/HIJ2. Put
this in a different column and dag down:

=A1&IF(COUNTIF(A$1:A1, A1) =1, "", COUNTIF(A$1:A1, A1)-1)

Greg

"Gaffnr" wrote:

Hi
I have a list of values that im using in a vlookup up. However, where in
rows they repeat, iwant to inrecment the value by 1 . e.g

Column A has
ABC
DEF
DEF
DEF
HIJ
HIJ
JKL
MNO

I want to turn this into, using a formula :
ABC
DEF
DEF1
DEF2
HIJ1
HIJ2
JKL
MNO

Thanks
Rob
--
Rob Gaffney