Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is There A Solution.......?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is There A Solution.......?
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is There A Solution.......?
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is There A Solution.......?
Glad to hear it....
Bernie MS Excel MVP Thank u, its working fine.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
solution wants | Excel Discussion (Misc queries) | |||
Web Solution | Excel Discussion (Misc queries) | |||
Need a solution! | Excel Programming | |||
Solution please | Excel Discussion (Misc queries) | |||
Is there a solution? | Excel Programming |