Most valuable professional
  • Hot Topics

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 Last edited by Usercode; Feb 3rd, 2018 at 08:34 PM.

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

This thread is current as of February 3, 2018.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel