adding sufixes

[#1]

hi,

i have few values in list box as below:

Names
India
Bangalore
Cochin
India
Hyderabad
Pune
Mumbai
Pune
Mumbai

as seen in the list box, there are duplicates like india, pune and mumbai so i need only these three names to be suffixed by India_S, Pune_S, and Mumbai_S

so my list box will be like this :

Names
India
Bangalore
Cochin
India_S
Hyderabad
Pune
Mumbai
Pune_S
Mumbai_S

please help

Regards

srujana

[MarcoWedel]

Hi,

maybe like this:

=Aggr(Names&If(RowNo()>1,'_S'),Names,ID)

hope this helps

regards

Marco