Is There A Solution.......?

[Thyagaraj]

Dear Friends,

I need to recognise the duplicate data in a selected range and add an
alphabet to the duplicate data.

Is this possible through a macro, can any one help.............?


Thanks in advance

Regards
Thyagaraj

 

[Bernie Deitrick]

How about a formula?

For data in column G, starting in row 2. Put this in cell H2, and copy down to match column G:

=IF(COUNTIF($G$2:G2,G2)=1,G2,G2&CHAR(COUNTIF($G$2:G2,G2)+63))

This will work for up to 26 duplicates....

HTH,
Bernie
MS Excel MVP

 

[Thyagaraj]

Dear Bernie Deitrick,


Thank u, its working fine....



Regards
Thyagaraj

 

[Bernie Deitrick]

Glad to hear it....

Bernie
MS Excel MVP