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

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" wrote in message
ps.com...
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

Dear Bernie Deitrick,


Thank u, its working fine....



Regards
Thyagaraj
Bernie Deitrick wrote:
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" wrote in message
ps.com...
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

Glad to hear it....

Bernie
MS Excel MVP


Thank u, its working fine....