I am looking to create a spread sheet that will have entries from 3 to 4 numbers. I am looking for a way to make the out put identify numbers that contain duplicates using letters ABCD. The input could be single cell or all numbers in one cell(1,2,3 or 123). Any help would be greatly appreciated. Thank you.
Example:
123 = ABC
122 = ABB
222 = AAA
322 = ABB
1234 = ABCD
4566 = ABCC
7778 = AAAB
7777 = AAAA
1229 = ABBC.
Bookmarks