Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
maybe like this:
=Aggr(Names&If(RowNo()>1,'_S'),Names,ID)
hope this helps
regards
Marco