Calculating the highest recurring "data" within a single cell

[BrerRabbit]

Yep, you read that correctly. And I know how unusual this sounds, but this is where I'm at.

I have a column of formulae that has extracted data from various other cells using the concatenate formula. There can be up to 17 separate instances, and as little as none or just one. The code can be a recurring code, or different. They are always three characters long, and separated by a comma. Otherwise it's just completely empty. Now I have to analyse what is within this one cell. I need to know the highest recurrence of the single three character code. I have absolutely no idea even how to start figuring this one out. If there even is an answer. If you don't believe that there is an answer to this one, please let me know.

APP,
APP, APP,
ORA, APP, ORA, APP,
CUC,
BAN, BAN, BAN, BAN, BAN, BAN, ORA,

 

[Automatrix]

It's a little unclear what you are asking. What would be the correct highest recurrence for the data shown?

 

[Armstrong_N14]

Maybe this (but this is in 365):

Book3
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ
1	Names	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17
2	APP,	APP																		APP - 1
3	APP, APP,	APP	APP																	APP - 2
4	ORA, APP, ORA, APP,	ORA	APP	ORA	APP															ORA - 2	APP - 2
5	CUC,	CUC																		CUC - 1
6	BAN,BAN,BAN,BAN,BAN,BAN,ORA,	BAN	BAN	BAN	BAN	BAN	BAN	ORA												BAN - 6	ORA - 1
7	ACN, CAN, ANC	ACN	CAN	ANC																ACN - 1	CAN - 1	ANC - 1
Sheet1

Cell Formulas
Range	Formula
C1:R1,U1:AJ1	C1	=B1+1
B2,B5,B7:D7,B6:H6,B4:E4,B3:C3	B2	=TRIM(TOROW(TEXTSPLIT(A2,,",",TRUE)))
T2:T3,T5,T7:V7,T6:U6,T4:U4	T2	=TOROW(FILTER(UNIQUE(TOCOL(B2:R2)),UNIQUE(TOCOL(B2:R2))<>""))& " - "&COUNTIF($B2:$R2,TOROW(FILTER(UNIQUE(TOCOL(B2:R2)),UNIQUE(TOCOL(B2:R2))<>"")))

 

[BrerRabbit]

Thank you. This'll work nicely.

Maybe this (but this is in 365):

Book3
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ
1	Names	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17
2	APP,	APP																		APP - 1
3	APP, APP,	APP	APP																	APP - 2
4	ORA, APP, ORA, APP,	ORA	APP	ORA	APP															ORA - 2	APP - 2
5	CUC,	CUC																		CUC - 1
6	BAN,BAN,BAN,BAN,BAN,BAN,ORA,	BAN	BAN	BAN	BAN	BAN	BAN	ORA												BAN - 6	ORA - 1
7	ACN, CAN, ANC	ACN	CAN	ANC																ACN - 1	CAN - 1	ANC - 1
Sheet1

Cell Formulas
Range	Formula
C1:R1,U1:AJ1	C1	=B1+1
B2,B5,B7:D7,B6:H6,B4:E4,B3:C3	B2	=TRIM(TOROW(TEXTSPLIT(A2,,",",TRUE)))
T2:T3,T5,T7:V7,T6:U6,T4:U4	T2	=TOROW(FILTER(UNIQUE(TOCOL(B2:R2)),UNIQUE(TOCOL(B2:R2))<>""))& " - "&COUNTIF($B2:$R2,TOROW(FILTER(UNIQUE(TOCOL(B2:R2)),UNIQUE(TOCOL(B2:R2))<>"")))

thank you. This will work nicely.