Excel: Counting the repeating values and displaying with alphanumeric symbols

Hello, I am not sure if this can be done with a formula, but if it is, I would appreciate the help. I have a set of data some of which can be repeated several times in the same row. And if the values are repeated, I'd like them to be displayed with alphanumeric symbols. For example, If data is (1,1,1,3,3,4,5), then the output should be 32R. (three 1s, two 3s). Since 4,5 and are not repeated, they are excluded. if data is (1,2,2,3,3,4,5), then the output should be 22R (two 2s and two 3s). I have attached an example worksheet. Thanks! https://1drv.ms/x/s!AoGkZUHlKui9gSEHkSskV6ynfmAJ

This question generated 17 answers. To proceed to the answers, click here.

This thread is current as of February 03, 2018.

For more resources for Microsoft Excel