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

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


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?


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


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