Counting the repeating values and displaying with alphanumeric symbols

[Usercode]

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

 

[Ingolf]

Hello Rick,
I tried to change the code written by you and I did not succeed.
Thanks for modifying the code.