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.
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.