Identifying possible duplicate cells in column and adding duplicates in new column for clarity

[Sarai1998]

Hello!
Is there a way to somehow change 2 cell values which are identifiable and almost similar to show as duplicate?
Like Column A consists the following data
wp/369/2021-22
369/2021-22
sh/2021/333
sh/333

Now i want excel to to make a new column in Column B and show the values either like this
wp/369/2021-22
wp/369/2021-22
sh/2021/333
sh/2021/333

Or like this
369/2021-22
369/2021-22
sh/333
sh/333

Or Any other combination so long as it is able to show the values as duplicates in a new column
Basically i just want it to identify that there is a cell which looks similar(either from start or mid or right) to other cell in the same column, and then make a new column which consists of duplicates(unique values should also exist in this newly created column, if excel fails to identify duplicate values). So i can use that column instead of the old one..

Please help me.

 

[Joe4]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Identifying possible duplicate cells in column and adding duplicates in new column for cla
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Sarai1998]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Identifying possible duplicate cells in column and adding duplicates in new column for cla
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

I'm sorry for breaking the rules. I misunderstood it ?

 

[Joe4]

Note that we do actually allow Cross-Posting, as long as you mention you are doing so and provide links to the other places where you asked the question.