text Join function

[vmjan02]

I have this formula and it is all perfect, but the result is in one single cell and i want it in different cells

Is there a way to modify the function to get the output ref screen shot 2.

=TEXTJOIN(" & ", TRUE, IF('Combined ALU'!$A:$A=$AC$3, INDEX('Combined ALU'!$C:$C, ROW('Combined ALU'!$C:$C)-ROW('Combined ALU'!C2)+1), ""))

result is

But actual output should be like this

 

[awoohaw]

your screenshots do not convey enough information to answer your question.
But, from your text, maybe you could try using TEXTSPLIT:
also, are you trying to get matching from the same row in A and C? If so, the +1 to the row needs to be adjusted here. I just tried to build the worksheet as you have it starting on Row 3.

Book1
	A	B	C	D																									AC	AD	AE	AF	AG
1
2
3	RFI		QWB																										JED		PQA	UYP	IWP
4	JED		ZET
5	CGT		PQA
6	LLE		RYI
7	APN		ZPT
8	FKH		GVK
9	FLG		YCM
10	EHU		PUQ
11	OWW		GDM
12	YNP		OBO
13	ZDV		MTW
14	JED		FYI
15	DJT		UYP
16	PLO		LTQ
17	IXV		TJL
18	ATD		TBG
19	JED		UDK
20	GKK		IWP
21	UHL		SWA
22	EXG		NFA
Sheet4

Cell Formulas
Range	Formula
AE3:AG3	AE3	=TEXTSPLIT(TEXTJOIN(" & ", TRUE, IF($A$3:$A$22=$AC$3, INDEX($C$3:$C$22, ROW($C$3:$C$22)-ROW(C2)+1), ""))," & ")
Dynamic array formulas.

 

[vmjan02]

Jira_Daily_Automation_V1.xlsm
	AC	AD
1
2		Short name
3	302-00_ETSLEA00OL9
4
5
Utilization Criteria P0

this is in the sheet by name Utilization Criteria P0 and


this is the range in the sheet Combined ALU.

Jira_Daily_Automation_V1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1	Shot Name Working	Site Name :- JIRA Data	Short name	NE_STATE		19-Mar-24	20-Mar-24	21-Mar-24	22-Mar-24	23-Mar-24	24-Mar-24	25-Mar-24
2	101-00_MURBRD00OL1	Not Avaliable	101-00_MURBRD00OL1-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	0.01	0.01	0.01	0	0	0.02	0.01
3	101-00_MURBRD00OL1	Not Avaliable	101-00_MURBRD00OL1-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	0.01	0.01	0.01	0	0	0.02	0.01
4	101-00_MURBRD00OL2	Not Avaliable	101-00_MURBRD00OL2-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	0.01	0.01	0.01	0	0	0.02	0.01
5	101-00_MURBRD00OL2	Not Avaliable	101-00_MURBRD00OL2-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	0.01	0.01	0.01	0	0	0.02	0.01
6	101-00_MURBRD00OL3	Not Avaliable	101-00_MURBRD00OL3-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	2.86	2.59	2.85	2.92	2.6	2.74	2.54
7	101-00_MURBRD00OL3	Not Avaliable	101-00_MURBRD00OL3-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	3.55	2.53	2.9	2.97	2.52	3.02	2.66
8	101-00_MURBRD00OL5	Not Avaliable	101-00_MURBRD00OL5-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	19.66	19.87	19.32	20.03	19.44	18.69	18.25
9	101-00_MURBRD00OL5	Not Avaliable	101-00_MURBRD00OL5-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	21.53	18.79	19.11	18.8	19.01	20.83	19.21
10	102-00_DBATRD00OL3	Not Avaliable	102-00_DBATRD00OL3-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	6.11	4.54	5.79	4.1	4.51	5.52	5.06
11	102-00_DBATRD00OL3	Not Avaliable	102-00_DBATRD00OL3-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	6.13	4.78	5.42	4.4	4.73	5.28	5.19
12	102-00_DBATRD00OL5	Not Avaliable	102-00_DBATRD00OL5-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	14.58	13.29	13.33	13.02	13.72	13.82	13.45
13	102-00_DBATRD00OL5	Not Avaliable	102-00_DBATRD00OL5-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	15.11	15.56	13.37	12.75	13.91	14.26	14.4
14	108-00_DLBNRDAROL3	108-00_DLBNRDAROL3	108-00_DLBNRDAROL3-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	98.21	96.36	95.42	96.54	94.84	96.07	94.32
15	108-00_DLBNRDAROL3	108-00_DLBNRDAROL3	108-00_DLBNRDAROL3-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	97.56	96.34	98.38	95.09	95.63	96.06	95.38
16	108-00_DLBNRDAROL9	108-00_DLBNRDAROL9	108-00_DLBNRDAROL9-nt-a:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	83.06	82.19	82.22	81.6	81.77	84.68	83.55
17	108-00_DLBNRDAROL9	108-00_DLBNRDAROL9	108-00_DLBNRDAROL9-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	89.89	85.14	87.26	84.85	81.85	88	86.38
18	108-00_DLBNRDAROL9	108-00_DLBNRDAROL9	108-00_DLBNRDAROL9-nt-b:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	86.15	85.41	85.91	86.15	82.84	89.09	82.81
19	108-00_DLBNRDAROL9	108-00_DLBNRDAROL9	108-00_DLBNRDAROL9-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	89.6	81.88	83.98	80.34	82.01	87.11	80.89
20	109-00_DHYTRDAXOL0	Not Avaliable	109-00_DHYTRDAXOL0-nt-a:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	3.54	4.57	4.42	3.66	3.07	3.79	2.92
21	109-00_DHYTRDAXOL0	Not Avaliable	109-00_DHYTRDAXOL0-nt-b:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	3.36	3.51	3.51	4.08	2.91	3.68	3.46
22	112-00_MRWARD00OL3	Not Avaliable	112-00_MRWARD00OL3-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	31.33	30.47	32.42	29.23	31.31	32.54	30.67
23	112-00_MRWARD00OL3	Not Avaliable	112-00_MRWARD00OL3-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	30.75	30.55	32.2	30.55	30.56	31.33	30.77
24	112-00_MRWARD00OL4	Not Avaliable	112-00_MRWARD00OL4-nt-a:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	42.1	43.31	46.36	42.22	43.52	45.14	44.18
25	112-00_MRWARD00OL4	Not Avaliable	112-00_MRWARD00OL4-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	42.6	43.92	42.18	42.56	43.35	44.43	45.18
26	112-00_MRWARD00OL4	Not Avaliable	112-00_MRWARD00OL4-nt-b:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	41.03	40.27	41.19	40.22	42.19	45.93	42.78
27	112-00_MRWARD00OL4	Not Avaliable	112-00_MRWARD00OL4-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	43.13	43.71	45.27	42.05	43.75	43.68	43.54
28	112-00_MRWARD00OL5	Not Avaliable	112-00_MRWARD00OL5-nt-a:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	47.12	46.79	48.61	47.47	49.39	52.14	47.79
29	112-00_MRWARD00OL5	Not Avaliable	112-00_MRWARD00OL5-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	43.25	41.52	42.02	41.04	43.74	45.08	43.2
30	112-00_MRWARD00OL5	Not Avaliable	112-00_MRWARD00OL5-nt-a:xfp:3	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	41.11	42.95	41.11	41.74	40.98	43.15	42.75
31	112-00_MRWARD00OL5	Not Avaliable	112-00_MRWARD00OL5-nt-b:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	46.59	45.95	45.06	46.01	48.25	48.05	47.78
32	112-00_MRWARD00OL5	Not Avaliable	112-00_MRWARD00OL5-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	43.74	47.67	42.65	45.6	43.54	45.24	42.73
33	112-00_MRWARD00OL5	Not Avaliable	112-00_MRWARD00OL5-nt-b:xfp:3	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	40.47	39.33	41.58	39.31	39.01	40.07	40.48
34	112-00_MRWARD00OL6	Not Avaliable	112-00_MRWARD00OL6-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	38.16	39.65	39.88	41.3	40.38	39.94	40.33
35	112-00_MRWARD00OL6	Not Avaliable	112-00_MRWARD00OL6-nt-a:xfp:3	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	36.9	39.03	36.32	35.03	36.63	38.17	36.53
36	112-00_MRWARD00OL6	Not Avaliable	112-00_MRWARD00OL6-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	40.17	41.29	41.07	40.99	40.16	42.8	40.33
37	112-00_MRWARD00OL6	Not Avaliable	112-00_MRWARD00OL6-nt-b:xfp:3	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	40.58	38.87	38.8	38.69	38.25	38.65	38.47
38	112-31_DERBRDAAOL2	Not Avaliable	112-31_DERBRDAAOL2-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	0.04	0.25	0.21	0.04	0.02	0.05	0.25
39	112-31_DERBRDAAOL2	Not Avaliable	112-31_DERBRDAAOL2-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	0.06	0.32	0.33	0.06	0.07	0.04	0.33
40	112-31_DERBRDAAOL4	112-31_DERBRDAAOL4	112-31_DERBRDAAOL4-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	52.87	53	50.89	52.44	51.18	54.33	52.66
41	112-31_DERBRDAAOL4	112-31_DERBRDAAOL4	112-31_DERBRDAAOL4-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	49.97	50.79	50.63	49.42	51.36	54.03	52.69
42	114-00_MNARRD00OL6	Not Avaliable	114-00_MNARRD00OL6-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	28.7	26.18	26.14	23.79	27.64	27.25	25.22
43	114-00_MNARRD00OL6	Not Avaliable	114-00_MNARRD00OL6-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	29.39	27.74	23.55	25.37	24.98	26.74	26.5
44	114-00_MNARRD00OL7	Not Avaliable	114-00_MNARRD00OL7-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	6.56	5.06	5.84	5.54	5.8	5.65	5.17
45	114-00_MNARRD00OL7	Not Avaliable	114-00_MNARRD00OL7-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	6.54	5.42	5.71	5.81	5.27	5.9	4.76
46	114-00_MNARRD00OL8	Not Avaliable	114-00_MNARRD00OL8-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	27.28	24.09	27.04	27.63	26.66	26.46	24.1
47	114-00_MNARRD00OL8	Not Avaliable	114-00_MNARRD00OL8-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	28.5	23.99	24.99	27.21	27.47	27.21	24.43
48	114-00_MNARRD00OL9	Not Avaliable	114-00_MNARRD00OL9-nt-a:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	38.24	40.38	39.03	40.35	40.63	39.23	40.23
49	114-00_MNARRD00OL9	Not Avaliable	114-00_MNARRD00OL9-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	37.74	36.41	37.42	37.86	38.58	37.66	36.43
50	114-00_MNARRD00OL9	Not Avaliable	114-00_MNARRD00OL9-nt-b:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	37.73	35.48	38.65	37.24	38.05	37.94	55.46
51	114-00_MNARRD00OL9	Not Avaliable	114-00_MNARRD00OL9-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	36.9	37.86	38.73	38.6	37.01	38.2	60.46
52	114-00_MNARRD00OLA	Not Avaliable	114-00_MNARRD00OLA-nt-a:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	35.2	33.91	33.47	33.53	33.01	34.34	33.46
53	114-00_MNARRD00OLA	Not Avaliable	114-00_MNARRD00OLA-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	33.25	32.85	32.64	33.59	33.66	34.38	32.68
54	114-00_MNARRD00OLA	Not Avaliable	114-00_MNARRD00OLA-nt-b:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	32.84	33.13	32.64	34.16	33.93	35.03	33.77
55	114-00_MNARRD00OLA	Not Avaliable	114-00_MNARRD00OLA-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	32.65	32.97	34.35	33.29	35.38	34.7	33.46
56	114-00_MNARRD00OLC	Not Avaliable	114-00_MNARRD00OLC-nt-a:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	48.73	47.61	48.37	49.91	49.71	49.83	49.95
57	114-00_MNARRD00OLC	Not Avaliable	114-00_MNARRD00OLC-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	47.98	47.28	47.93	47.69	49.38	50.41	47.77
58	114-00_MNARRD00OLC	Not Avaliable	114-00_MNARRD00OLC-nt-a:xfp:3	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	44.26	41.85	42.21	45.12	43.15	41.84	41.32
59	114-00_MNARRD00OLC	Not Avaliable	114-00_MNARRD00OLC-nt-b:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	47.59	45.58	46.41	47.77	50.15	48.55	48.53
60	114-00_MNARRD00OLC	Not Avaliable	114-00_MNARRD00OLC-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	49.38	53.72	48.94	50.88	50.55	49.27	47.58
61	114-00_MNARRD00OLC	Not Avaliable	114-00_MNARRD00OLC-nt-b:xfp:3	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	44.38	44.99	43.73	45.56	46.43	50.13	43.38
62	114-00_MNARRD00OLE	Not Avaliable	114-00_MNARRD00OLE-nt-a:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	36.52	38.52	38.27	36.72	37.82	38.81	36.85
63	114-00_MNARRD00OLE	Not Avaliable	114-00_MNARRD00OLE-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	39.04	38.55	41.03	39.5	40.4	40.25	38.96
64	114-00_MNARRD00OLE	Not Avaliable	114-00_MNARRD00OLE-nt-b:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	36.02	34.58	34.63	34.84	36.66	39.27	37.14
65	114-00_MNARRD00OLE	Not Avaliable	114-00_MNARRD00OLE-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	35.8	34.59	35.56	35.49	37.59	36.7	36.84
66	114-00_MNARRD00OLF	Not Avaliable	114-00_MNARRD00OLF-nt-a:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	36.2	37.69	36.28	39.49	38.56	37.78	35.94
67	114-00_MNARRD00OLF	Not Avaliable	114-00_MNARRD00OLF-nt-b:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	38.93	36.65	35.2	37.42	38	37.35	36.78
68	116-00_MRSTRDEEOL0	Not Avaliable	116-00_MRSTRDEEOL0-nt-a:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	0.01	0	0	0	0	0.01	0
69	117-00_ESKNRD00OL3	Not Avaliable	117-00_ESKNRD00OL3-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	42.07	42.69	42.02	45.94	41.35	41.81	40.03
70	117-00_ESKNRD00OL3	Not Avaliable	117-00_ESKNRD00OL3-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	41.25	42.43	41.78	46.13	41.67	41.8	40.14
71	117-00_ESKNRD00OL4	Not Avaliable	117-00_ESKNRD00OL4-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	51.76	52.23	49.98	53.89	51.59	51.89	51.97
72	117-00_ESKNRD00OL4	Not Avaliable	117-00_ESKNRD00OL4-nt-a:xfp:3	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	49.22	51.09	48.07	51.46	51.6	48.39	49.12
73	117-00_ESKNRD00OL4	Not Avaliable	117-00_ESKNRD00OL4-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	51.53	53	48.67	50.64	50.56	52.12	51.2
74	117-00_ESKNRD00OL4	Not Avaliable	117-00_ESKNRD00OL4-nt-b:xfp:3	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	50.26	50.58	49.01	53.27	50.71	51.6	52.27
75	117-00_ESKNRD00OL5	Not Avaliable	117-00_ESKNRD00OL5-nt-a:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	34.4	33.3	31.95	32.86	35.82	34.69	35.62
76	117-00_ESKNRD00OL5	Not Avaliable	117-00_ESKNRD00OL5-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	35.8	34.94	33.67	35.11	35.21	35.58	33.25
77	117-00_ESKNRD00OL5	Not Avaliable	117-00_ESKNRD00OL5-nt-b:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	31.61	31.32	31.98	30.81	33.44	33.19	32.01
78	117-00_ESKNRD00OL5	Not Avaliable	117-00_ESKNRD00OL5-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	32.89	32.14	34.77	36.93	34.16	32.77	34.63
79	117-00_ESKNRD00OL6	Not Avaliable	117-00_ESKNRD00OL6-nt-a:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	42.14	42.75	39.99	39.41	40.06	40.07	37.44
80	117-00_ESKNRD00OL6	Not Avaliable	117-00_ESKNRD00OL6-nt-b:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	40.88	42.27	41.78	41.43	42.74	42.82	38.51
81	118-00_NOURRDAAOL2	118-00_NOURRDAAOL2	118-00_NOURRDAAOL2-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	59.27	58.07	57.92	67.07	64.83	61.95	60.87
82	118-00_NOURRDAAOL2	118-00_NOURRDAAOL2	118-00_NOURRDAAOL2-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	58.88	59.2	59.03	68.45	64.42	61.68	62
83	119-00_RFEHRD00OL2	Not Avaliable	119-00_RFEHRD00OL2-nt-a:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	34.31	33.82	32.91	31.8	32.98	35.69	33.99
84	119-00_RFEHRD00OL2	Not Avaliable	119-00_RFEHRD00OL2-nt-b:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	32.61	32.03	33.39	31.15	33.65	33.07	33.41
85	130-00_KHRJRD00OL3	Not Avaliable	130-00_KHRJRD00OL3-nt-a:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	13.74	14.02	14.57	15.92	15.51	13.96	14.07
86	130-00_KHRJRD00OL3	Not Avaliable	130-00_KHRJRD00OL3-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	13.33	14.11	14.35	15.15	16.32	14.81	14.59
87	130-00_KHRJRD00OL3	Not Avaliable	130-00_KHRJRD00OL3-nt-b:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	13.24	14.35	14.26	16.09	15.22	15.38	13.77
88	130-00_KHRJRD00OL3	Not Avaliable	130-00_KHRJRD00OL3-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	14.49	14.41	14.47	16.38	14.77	13.51	13.51
89	130-00_KHRJRD00OL6	Not Avaliable	130-00_KHRJRD00OL6-nt-a:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	18.38	18.41	20.77	18.32	18.41	18.62	17.03
90	130-00_KHRJRD00OL6	Not Avaliable	130-00_KHRJRD00OL6-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	18.32	18.68	19.78	18.62	17.47	19.51	17.94
91	130-00_KHRJRD00OL6	Not Avaliable	130-00_KHRJRD00OL6-nt-b:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	18.47	19	19.67	18.76	17.97	19.84	18.5
92	130-00_KHRJRD00OL6	Not Avaliable	130-00_KHRJRD00OL6-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	19.03	19.86	19.63	17.86	17.86	19.81	18.64
93	130-00_KHRJRD00OL7	Not Avaliable	130-00_KHRJRD00OL7-nt-a:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	61	57.72	59.65	62.28	63.69	60.8	63.08
94	130-00_KHRJRD00OL7	Not Avaliable	130-00_KHRJRD00OL7-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	60.93	60.29	62.03	63.78	63.31	62.84	62.39
95	130-00_KHRJRD00OL7	Not Avaliable	130-00_KHRJRD00OL7-nt-b:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	58.53	58.22	57.58	59.36	59.75	60.31	57.22
96	130-00_KHRJRD00OL7	Not Avaliable	130-00_KHRJRD00OL7-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	59.19	57.02	58.5	61.49	59.86	58.62	55.78
97	130-00_KHRJRD00OL8	Not Avaliable	130-00_KHRJRD00OL8-nt-a:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	52.38	54.57	52.71	55.29	51.43	52.45	50.82
98	130-00_KHRJRD00OL8	Not Avaliable	130-00_KHRJRD00OL8-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	55.16	56.81	56.32	60.22	57.48	58.42	56.7
99	130-00_KHRJRD00OL8	Not Avaliable	130-00_KHRJRD00OL8-nt-a:xfp:3	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	50.9	53.71	54.92	53.76	52.53	53.11	55
100	130-00_KHRJRD00OL8	Not Avaliable	130-00_KHRJRD00OL8-nt-b:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	52.94	56.32	53.04	52.45	53.71	52.34	50.51
101	130-00_KHRJRD00OL8	Not Avaliable	130-00_KHRJRD00OL8-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	50.42	53.77	50.75	50.5	51.14	48.4	49.4
102	130-00_KHRJRD00OL8	Not Avaliable	130-00_KHRJRD00OL8-nt-b:xfp:3	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	50.69	50.26	57.21	52.2	49	51.38	52.17
103	130-00_RFAIRDASOL1	Not Avaliable	130-00_RFAIRDASOL1-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	7.51	7.46	7.96	8.32	6.39	7.33	7.23
104	130-00_RFAIRDASOL1	Not Avaliable	130-00_RFAIRDASOL1-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	6.97	6.61	6.61	6.79	7.93	7.12	7.24
105	172-00_RMALRDAZOL4	Not Avaliable	172-00_RMALRDAZOL4-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	56.35	50.17	53.6	48.6	50.99	49.55	46.95
106	172-00_RMALRDAZOL4	Not Avaliable	172-00_RMALRDAZOL4-nt-a:xfp:3	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	57.88	50.38	51.59	47.3	50.86	50.42	47.7
107	172-00_RMALRDAZOL4	Not Avaliable	172-00_RMALRDAZOL4-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	56.48	50.47	50.27	49.43	50.88	52.23	47.04
108	172-00_RMALRDAZOL4	Not Avaliable	172-00_RMALRDAZOL4-nt-b:xfp:3	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	50.33	50.12	49.89	48.3	48.51	49.67	47.05
109	172-00_RMALRDAZOL5	Not Avaliable	172-00_RMALRDAZOL5-nt-a:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	47.76	47.28	46.7	49.84	49.61	46.06	44.77
110	172-00_RMALRDAZOL5	Not Avaliable	172-00_RMALRDAZOL5-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	45.57	45.14	46.91	47.1	47.6	47.09	43.66
111	172-00_RMALRDAZOL5	Not Avaliable	172-00_RMALRDAZOL5-nt-b:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	46.59	47.64	47.99	50.3	48.49	45.21	47.23
112	172-00_RMALRDAZOL5	Not Avaliable	172-00_RMALRDAZOL5-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	49.28	47.12	50.36	46.65	51.37	47.44	47.16
113	199-00_KHRJRD03OL0	Not Avaliable	199-00_KHRJRD03OL0-nt-a:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	18.52	17.58	18.13	18.68	20.86	21.55	20.33
114	199-00_KHRJRD03OL0	Not Avaliable	199-00_KHRJRD03OL0-nt-b:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	17.75	18.36	17.82	17.43	16.83	18.37	17.64
115	201-00_AMARKH00OL0	Not Avaliable	201-00_AMARKH00OL0-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	17.88	19.32	18.55	18.91	18.89	18.86	19.32
116	201-00_AMARKH00OL0	Not Avaliable	201-00_AMARKH00OL0-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	19.83	20.37	20.96	20.87	20.1	20.2	19.23
117	202-00_MSRFKH00OL2	Not Avaliable	202-00_MSRFKH00OL2-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	19.25	18.65	17.59	18.26	18.05	17.95	18.24
118	202-00_MSRFKH00OL2	Not Avaliable	202-00_MSRFKH00OL2-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	18.61	18.35	19.22	18.4	19.19	18.58	18.59
119	202-00_MSRFKH00OL3	Not Avaliable	202-00_MSRFKH00OL3-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	12.44	11.51	10.97	11.42	12.76	12.02	11.63
120	202-00_MSRFKH00OL3	Not Avaliable	202-00_MSRFKH00OL3-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	11.3	11.68	10.55	11.14	11.26	10.89	10.09
121	202-00_MSRFKH00OL4	Not Avaliable	202-00_MSRFKH00OL4-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	11.08	13.67	13.99	13	13.33	12.81	13.33
122	202-00_MSRFKH00OL4	Not Avaliable	202-00_MSRFKH00OL4-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	10.94	13.76	14.56	12.29	12.66	13.7	14.07
123	202-00_MSRFKH00OL5	Not Avaliable	202-00_MSRFKH00OL5-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	35.74	36.97	35.25	34.6	34.76	35.86	34.88
124	202-00_MSRFKH00OL5	Not Avaliable	202-00_MSRFKH00OL5-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	35.28	35.06	34.61	32.92	31.93	33.37	30.83
125	202-00_MSRFKH00OL6	Not Avaliable	202-00_MSRFKH00OL6-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	9.28	5.59	4.97	3.09	4.5	5.81	6.58
126	202-00_MSRFKH00OL6	Not Avaliable	202-00_MSRFKH00OL6-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	9.27	5.46	5.01	3.12	4.21	5.69	6.41
127	202-00_MSRFKH00OL7	Not Avaliable	202-00_MSRFKH00OL7-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	4.8	5.64	3.73	5.04	3.87	4.96	4.01
128	202-00_MSRFKH00OL7	Not Avaliable	202-00_MSRFKH00OL7-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	5.38	5.04	4.59	4.8	4.61	4.64	4.43
129	202-00_MSRFKH00OLA	Not Avaliable	202-00_MSRFKH00OLA-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	1.41	1.48	1.31	0.69	0.66	1.46	1.24
130	202-00_MSRFKH00OLA	Not Avaliable	202-00_MSRFKH00OLA-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	1.58	1.4	1.35	0.78	0.62	1.4	1.45
131	202-00_MSRFKH00OLC	Not Avaliable	202-00_MSRFKH00OLC-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	0.01	0.01	0	0	0	0.02	0
132	202-00_MSRFKH00OLC	Not Avaliable	202-00_MSRFKH00OLC-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	0.01	0.01	0	0	0	0.01	0
133	202-00_MSRFKH00OLF	Not Avaliable	202-00_MSRFKH00OLF-nt-a:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	31.41	32.26	33.61	32.65	33.73	33.92	34.05
134	202-00_MSRFKH00OLF	Not Avaliable	202-00_MSRFKH00OLF-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	28.31	29.61	29.05	29	28.2	27.72	27.06
135	202-00_MSRFKH00OLF	Not Avaliable	202-00_MSRFKH00OLF-nt-b:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	30.76	30.69	30.87	32.85	30.14	29.42	30.71
136	202-00_MSRFKH00OLF	Not Avaliable	202-00_MSRFKH00OLF-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	32.08	31.97	32.62	33.72	31.98	33.97	33.06
137	203-00_SLMJKH00OL0	Not Avaliable	203-00_SLMJKH00OL0-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	10.54	9.83	8.37	7.6	8.39	9.45	7.68
138	203-00_SLMJKH00OL0	Not Avaliable	203-00_SLMJKH00OL0-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	10.37	9.01	10.42	8.4	8.42	8.22	8.5
139	203-00_SLMJKH00OL1	Not Avaliable	203-00_SLMJKH00OL1-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	30.99	32.57	29.63	29.3	29.8	30.97	30.55
140	203-00_SLMJKH00OL1	Not Avaliable	203-00_SLMJKH00OL1-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	31.78	32.68	31.83	32.49	32.66	32.21	30.65
141	204-00_KHMRKHAAOL1	Not Avaliable	204-00_KHMRKHAAOL1-nt-a:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	13.37	12.51	12.74	9.51	10.18	13.21	12.54
142	204-00_KHMRKHAAOL1	Not Avaliable	204-00_KHMRKHAAOL1-nt-b:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	12.26	13.11	12.11	8.74	10.82	12.57	13.15
143	204-00_MSTWKHATOL1	Not Avaliable	204-00_MSTWKHATOL1-nt-a:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	5.93	5.98	5.66	6.15	6.12	6.15	6.02
144	204-00_MSTWKHATOL1	Not Avaliable	204-00_MSTWKHATOL1-nt-b:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	6.71	5.61	5.25	5.66	5.27	5.39	6
145	204-00_NYMNKH01OL1	Not Avaliable	204-00_NYMNKH01OL1-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	38.06	37.77	35.35	38.77	37.99	38.24	39.33
146	204-00_NYMNKH01OL1	Not Avaliable	204-00_NYMNKH01OL1-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	38.68	38.27	35.7	39.1	37.55	38.26	39.37
147	204-00_NYMNKH01OL5	Not Avaliable	204-00_NYMNKH01OL5-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	19.18	18.9	18.71	19.37	18.72	20.73	18.2
148	204-00_NYMNKH01OL5	Not Avaliable	204-00_NYMNKH01OL5-nt-a:xfp:3	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	22.41	19.93	19.49	20.4	19.83	19.88	19.75
149	204-00_NYMNKH01OL5	Not Avaliable	204-00_NYMNKH01OL5-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	19.91	20.78	20.9	20.43	20.79	20.95	20.93
150	204-00_NYMNKH01OL5	Not Avaliable	204-00_NYMNKH01OL5-nt-b:xfp:3	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	19.53	20.55	19.98	19.74	19.41	20.01	20.39
151	204-00_NYMNKH01OL7	Not Avaliable	204-00_NYMNKH01OL7-nt-a:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	39.63	40.42	40.04	39.3	41.7	38.82	40.32
152	204-00_NYMNKH01OL7	Not Avaliable	204-00_NYMNKH01OL7-nt-b:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	40.7	39.27	40.26	39.47	40.92	40.61	42.08
153	204-00_WADEKHAAOL0	Not Avaliable	204-00_WADEKHAAOL0-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	12.21	12.32	11.46	11.69	13.47	11.7	11.99
154	204-00_WADEKHAAOL0	Not Avaliable	204-00_WADEKHAAOL0-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	11.71	12.56	12.08	12.48	13.18	12.59	12.28
155	204-00_WADEKHAAOL2	Not Avaliable	204-00_WADEKHAAOL2-nt-a:xfp:1	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	47.68	46.41	44.58	44.08	45.28	48.38	48.23
156	204-00_WADEKHAAOL2	Not Avaliable	204-00_WADEKHAAOL2-nt-a:xfp:3	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	54.26	53.62	50.82	50.48	54.03	55.22	53.7
157	204-00_WADEKHAAOL2	Not Avaliable	204-00_WADEKHAAOL2-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	48.35	44.32	43.4	45.69	46.92	44.88	47.27
158	204-00_WADEKHAAOL2	Not Avaliable	204-00_WADEKHAAOL2-nt-b:xfp:3	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	54.88	51.9	51.48	52.39	56.75	53.01	55.44
159	205-00_KLDYKHABOL2	Not Avaliable	205-00_KLDYKHABOL2-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	0.3	0.64	0.3	0.26	0.22	0.21	0.29
160	205-00_KLDYKHABOL2	Not Avaliable	205-00_KLDYKHABOL2-nt-a:xfp:3	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	0.01	0	0	0	0	0	0
161	205-00_KLDYKHABOL2	Not Avaliable	205-00_KLDYKHABOL2-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	0.23	0.67	0.3	0.23	0.32	0.34	0.29
162	205-00_KLDYKHABOL3	Not Avaliable	205-00_KLDYKHABOL3-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	1.09	0.78	0.97	0.86	0.73	0.89	0.75
163	205-00_KLDYKHABOL3	Not Avaliable	205-00_KLDYKHABOL3-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	0.73	0.57	0.77	2.32	0.75	0.7	0.67
164	205-00_SLMHKH00OL5	Not Avaliable	205-00_SLMHKH00OL5-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	27.65	26.54	25.92	25.8	27.71	26.76	26.53
165	205-00_SLMHKH00OL5	Not Avaliable	205-00_SLMHKH00OL5-nt-a:xfp:3	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	29.27	27.6	26.93	27.29	26.96	26.17	25.91
166	205-00_SLMHKH00OL5	Not Avaliable	205-00_SLMHKH00OL5-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	29.11	26.9	25.56	26.02	27.26	26	26.11
167	205-00_SLMHKH00OL5	Not Avaliable	205-00_SLMHKH00OL5-nt-b:xfp:3	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	28.79	26.32	25.9	26.22	26.98	25.57	26.47
168	205-00_SLMHKH00OL6	Not Avaliable	205-00_SLMHKH00OL6-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	29.1	31.79	28.23	27.04	30.91	28.64	29.5
169	205-00_SLMHKH00OL6	Not Avaliable	205-00_SLMHKH00OL6-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	30.24	30.1	26.23	27.3	29.77	29.29	28.49
170	205-00_SLMHKH00OL7	Not Avaliable	205-00_SLMHKH00OL7-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	42.45	39.7	40.63	36.83	38.87	38.01	40.01
171	205-00_SLMHKH00OL7	Not Avaliable	205-00_SLMHKH00OL7-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	43.66	40.36	40.4	37.46	39.57	37.81	40.17
172	205-00_SLMHKH00OL8	Not Avaliable	205-00_SLMHKH00OL8-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	35.15	32.25	34.07	30.87	33.25	32.83	31.71
173	205-00_SLMHKH00OL8	Not Avaliable	205-00_SLMHKH00OL8-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	34.41	33.24	32.72	31.1	34.41	31.55	30.09
174	205-00_SLMHKH00OLA	Not Avaliable	205-00_SLMHKH00OLA-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	9.29	7.8	6.99	7.36	7.77	7.68	7.58
175	205-00_SLMHKH00OLA	Not Avaliable	205-00_SLMHKH00OLA-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	8.46	8.1	7.67	7.56	7.05	7.9	6.96
176	205-00_SLMHKH00OLC	Not Avaliable	205-00_SLMHKH00OLC-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	27.69	25.72	28.69	25.03	27.02	25.96	26.41
177	205-00_SLMHKH00OLC	Not Avaliable	205-00_SLMHKH00OLC-nt-b:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	28.15	27.91	29.9	27.38	27.82	27.06	25.38
178	205-00_SLMHKH00OLE	Not Avaliable	205-00_SLMHKH00OLE-nt-a:xfp:2	Active	ALU - OLT - Uplink Traffic In Rate Peak % - F	0.01	0.01	0	0	0	0.02	0
Combined ALU

 

[vmjan02]

your screenshots do not convey enough information to answer your question.
But, from your text, maybe you could try using TEXTSPLIT:
also, are you trying to get matching from the same row in A and C? If so, the +1 to the row needs to be adjusted here. I just tried to build the worksheet as you have it starting on Row 3.

Book1
	A	B	C	D																									AC	AD	AE	AF	AG
1
2
3	RFI		QWB																										JED		PQA	UYP	IWP
4	JED		ZET
5	CGT		PQA
6	LLE		RYI
7	APN		ZPT
8	FKH		GVK
9	FLG		YCM
10	EHU		PUQ
11	OWW		GDM
12	YNP		OBO
13	ZDV		MTW
14	JED		FYI
15	DJT		UYP
16	PLO		LTQ
17	IXV		TJL
18	ATD		TBG
19	JED		UDK
20	GKK		IWP
21	UHL		SWA
22	EXG		NFA
Sheet4

Cell Formulas
Range	Formula
AE3:AG3	AE3	=TEXTSPLIT(TEXTJOIN(" & ", TRUE, IF($A$3:$A$22=$AC$3, INDEX($C$3:$C$22, ROW($C$3:$C$22)-ROW(C2)+1), ""))," & ")
Dynamic array formulas.

this is what is the output i am looking for but the filter function don't work in 2016, so looking out for alternative formula. I hope this will help.

Jira_Daily_Automation_V1.xlsm
	AC	AD
1
2		Short name
3	302-00_ETSLEA00OL9	302-00_ETSLEA00OL9-ethernet0/10/0
4		302-00_ETSLEA00OL9-ethernet0/10/1
5		302-00_ETSLEA00OL9-ethernet0/9/0
6		302-00_ETSLEA00OL9-ethernet0/9/1
Utilization Criteria P0

Cell Formulas
Range	Formula
AD3:AD6	AD3	=FILTER('Combined ALU'!C:C,'Combined ALU'!A:A=$AC$3,"")
Dynamic array formulas.

 

[Peter_SSs]

the filter function don't work in 2016,

This is the first mention of 2016 in the whole thread and your profile does not mention that version.

You also showed some output using TEXTJOIN which is not available in Excel 2016

So how would helpers be expected to know you wanted any solution to work in Excel 2016?

 

[vmjan02]

This is the first mention of 2016 in the whole thread and your profile does not mention that version.

View attachment 109250
You also showed some output using TEXTJOIN which is not available in Excel 2016

So how would helpers be expected to know you wanted any solution to work in Excel 2016?

ok, i did updated my profile, not sure as how it missed, will do it

 

[Peter_SSs]

ok, i did updated my profile, not sure as how it missed, will do it

Just the same - there is no mention in any of the early part of the thread that you want the solution to work in excel 2016.
If you list 365 as one of your versions it is reasonable that helpers could suggest solutions that work in that version.