Array formula - =Char - Adds letters after duplicate numbers in order

by Ceebee86   Last Updated July 16, 2019 16:03 PM

Afternoon,

The below formula adds a letter after a sequential number, A, B, C D etc for the same number, until it finds a new number, then it starts again from A.

I need help on turning this into an array formula, if possible?

=J3&CHAR(96+COUNTIF(J$3:J3,J3))

I tried it this way, and depending if I amend J3:J3, I get either A or D at end of number?

={"";arrayformula(J3:J&CHAR(96+COUNTIF(J$3:J,J3:J)))}

The formula as a single line, pushes out the below.

enter image description here



Related Questions


Import range from 3 sheets/tabs into 4th

Updated February 06, 2019 12:03 PM



Aggregate results by week and month for charts

Updated January 18, 2019 09:03 AM