LinkBack URL
About LinkBacks
Hi All,
I need a code not formula that code looks of specific sheet column A find duplicate strings then rename like if find "test" 4 times in a column the rename it likt test1,test2,test3,test4 and so on with other duplicates.
Thank you
Farrukh
Renaming duplicate string in a column
Hi All,
I need a code not formula that code looks of specific sheet column A find duplicate strings then rename like if find "test" 4 times in a column the rename it likt test1,test2,test3,test4 and so on with other duplicates.
Thank you
Farrukh
Is this data only 1 in column? Can you attach a sample file?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
option
Please Login or Register to view this content.
hello, I cannot make it work and I need this also but in column B4:B300 only to automatically rename the second or duplicated with "duplicated".
bump for this.
Hello! please help
Its better to attach a sample worksheet. With before and after running code.
Quang PT
Here it is. A macro will do.
Try:
HTML Code:
Oh! the sample works! However. in the actual worksheet it starts at B4. When I changed the B3 to B4 it gives me an error.
I manage to make it work by editing some of it but it gives other responses. Kindly check this file.
Last edited by archvanarl; 06-29-2022 at 03:36 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks