Dynamic Array Count Games Played

[Stephen_IV]

I am looking for a Dynamic Array formula that can get the quarterback and sum games played in one formula. Thanks in advance!

Book19 A B C D E F G 1 Eli Manning (15) / Geno Smith (1) Eli Manning 15 Eli Manning 35 2 Eli Manning (16) Geno Smith 1 Geno Smith 1 3 Daniel Jones (12) / Eli Manning (4) Eli Manning 16 Daniel Jones 59 4 Daniel Jones (14) / Colt McCoy (2) Daniel Jones 12 Colt McCoy 2 5 Daniel Jones (11) / Mike Glennon (4) / Jake Fromm (2) Eli Manning 4 Mike Glennon 4 6 Daniel Jones (16) / Davis Webb (1) Daniel Jones 14 Jake Fromm 2 7 Daniel Jones (6) / Tommy DeVito (6) / Tyrod Taylor (4) Colt McCoy 2 Davis Webb 1 8 Daniel Jones 11 Tommy DeVito 6 9 Mike Glennon 4 Tyrod Taylor 4 10 Jake Fromm 2 11 Daniel Jones 16 12 Davis Webb 1 13 Daniel Jones 6 14 Tommy DeVito 6 15 Tyrod Taylor 4 Sheet1 Cell Formulas Range Formula C1:D15 C1 =WRAPROWS(TOCOL(LET(x,TEXTSPLIT(TEXTJOIN("|",1,A1:A7),{" / ","(",")"},"|",,,""),IF(x<>"",x,1/0)),3), 2) F1:F9 F1 =UNIQUE(C1:C15) G1:G9 G1 =SUM(IF($C$1:$C$15=F1,--$D$1:$D$15,"")) Dynamic array formulas.

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D
1	Eli Manning (15) / Geno Smith (1)		Eli Manning	35
2	Eli Manning (16)		Geno Smith	1
3	Daniel Jones (12) / Eli Manning (4)		Daniel Jones	59
4	Daniel Jones (14) / Colt McCoy (2)		Colt McCoy	2
5	Daniel Jones (11) / Mike Glennon (4) / Jake Fromm (2)		Mike Glennon	4
6	Daniel Jones (16) / Davis Webb (1)		Jake Fromm	2
7	Daniel Jones (6) / Tommy DeVito (6) / Tyrod Taylor (4)		Davis Webb	1
8			Tommy DeVito	6
9			Tyrod Taylor	4
10
Data

Cell Formulas
Range	Formula
C1:D9	C1	=LET(d,DROP(REDUCE("",A1:A7,LAMBDA(x,y,VSTACK(x,WRAPROWS(TOCOL(TRIM(TEXTSPLIT(y,{" /","(",")"},,1)),2),2)))),1),u,UNIQUE(INDEX(d,,1)),HSTACK(u,MAP(u,LAMBDA(m,SUM(IF(INDEX(d,,1)=m,--INDEX(d,,2),0))))))
Dynamic array formulas.

 

[Stephen_IV]

Beautiful!! Thank you Fluff! Have a fantastic New Year! God bless!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[JGordon11]

Book2
	A	B	C	D	E
1	Eli Manning (15) / Geno Smith (1)		Eli Manning	35
2	Eli Manning (16)		Geno Smith	1
3	Daniel Jones (12) / Eli Manning (4)		Daniel Jones	59
4	Daniel Jones (14) / Colt McCoy (2)		Colt McCoy	2
5	Daniel Jones (11) / Mike Glennon (4) / Jake Fromm (2)		Mike Glennon	4
6	Daniel Jones (16) / Davis Webb (1)		Jake Fromm	2
7	Daniel Jones (6) / Tommy DeVito (6) / Tyrod Taylor (4)		Davis Webb	1
8			Tommy DeVito	6
9			Tyrod Taylor	4
10
Sheet1

Cell Formulas
Range	Formula
C1:D9	C1	=LET( a, TEXTSPLIT(TEXTJOIN(" / ",1,A1:A7),," / "), b, TEXTBEFORE(a, " ("), c, TEXTAFTER(a, " ("), d, --LEFT(c,LEN(c)-1), e, UNIQUE(b), f, MMULT(--(e=TRANSPOSE(b)), d), HSTACK(e,f))
Dynamic array formulas.

 

[Stephen_IV]

JGordon11 Nice!! Thank you!!!