I have an excel list around 500 need to change numbers of any duplicates on the list. For example if there are duplicate part numbers:
1234
1234
1234
I need this changed by adding "A" "B" etc for example :
1234 - A
1234 - B
1234 - C
etc
1234 - AA
1234 - AB
etc.
any solution for this
1234
1234
1234
I need this changed by adding "A" "B" etc for example :
1234 - A
1234 - B
1234 - C
etc
1234 - AA
1234 - AB
etc.
any solution for this