Number Classification

[33sameer33]

Hello Everyone

I need a formula to classify list of numbers so that the first number is given a letter, and if the next number is different, it gives it another letter, and if the number is repeated, the first letter is given.

Please see an example in the attached file


Best Regards

 

[vletm]

33sameer33
One sample ...

 

[33sameer33]

33sameer33
One sample ...

This is not exactly what I wanted.
I want it like this

											Yours	I want it like this
7	0	0	0	0	0	0	0	0			HAAAAAAAA	HAAAAAAAA
7	0	0	0	0	0	0	0	1			HAAAAAAAB	HAAAAAAAB
7	0	0	0	0	0	0	0	2			HAAAAAAAC	HAAAAAAAB
7	0	0	0	0	0	0	0	3			HAAAAAAAD	HAAAAAAAB
7	0	0	0	0	0	0	0	4			HAAAAAAAE	HAAAAAAAB
7	0	0	0	0	0	0	0	5			HAAAAAAAF	HAAAAAAAB
7	0	0	0	0	0	0	0	6			HAAAAAAAG	HAAAAAAAB
7	0	0	0	0	0	0	0	7			HAAAAAAAH	HAAAAAAAB
7	0	0	0	0	0	0	0	8			HAAAAAAAI	HAAAAAAAB
7	0	0	0	0	0	0	0	9			HAAAAAAAJ	HAAAAAAAB

 

[vletm]

33sameer33
Do You have some clear logic for that?
> why the 1st letter is H?
> why 2nd letter is A
> why the last letter is B? except in the 1st line?
> what would You want if any of those zeros would get something else?

 

[John Jairo V]

Hi to all!

One option with Excel 2021/365 version:
=CONCAT(CHAR(96+MATCH(A2:I2,UNIQUE(A2:I2,1),)))
Another option (with Excel 2016) in attach file:
Blessings!

 

[33sameer33]

Hi to all!

One option with Excel 2021/365 version:
=CONCAT(CHAR(96+MATCH(A2:I2,UNIQUE(A2:I2,1),)))
Another option (with Excel 2016) in attach file:
Blessings!

That exactly what I wanted.
Many Thanks brother
Your are the best
and thanks to others for their kind support

 

[Pasadu]

That exactly what I wanted.
Many Thanks brother
Your are the best
and thanks to others for their kind support

All our teachers are the best. Be mindful of rating one above the other, for they all do marvelous works for us. Thank You John Jairo, thank you Vletm

 

[33sameer33]

All our teachers are the best. Be mindful of rating one above the other, for they all do marvelous works for us. Thank You John Jairo, thank you Vletm

I agree with you. All teachers in this group are the best.

Thank you all

 

[jutu]

That was an interesting lesson. I have similar problem and will be able to use it.
Sorry if I interfere in this query but if you can please explain it so that I can apply it to mine more accurately please, if possible.
I understand char is for 96 characters, but not sure of the formula. Like the "1" in UNIQUE function

=CONCAT(CHAR(96+MATCH(A2:I2,UNIQUE(A2:I2,1),)))