Complicated countif formula

[Ev1lZer0]

Good Morning,

I have a list of 22,528 docket description entries (Column F), most of which are useless. My goal is to extract the number of times certain text appears. And for excel to do it automatically. For instance. I am hoping that Excel can create another table (similar to G2:I4 - without the colors...) that would include a list of EVERY instance column F shows "Judge: . . ." I would then want Excel to take the entire contents of that cell and place it in column H. For instance, F5 and F10 both contain "JUDGE: TUTSCH, ELISABETH M" this should be listed ONCE in column H - as it is in H2.

Additionally, I want excel to count the number of instances this exact text appears in column F. In my example, it appears 17 times. But there is a catch. I only want it to count that exact text once per "Case Key" instance. In my example, "JUDGE: TUTSCH, ELISABETH M" appears 17 times, but only in 3 different case keys.

If it is easier, all rows containing something other than "Judge: . . ." can be deleted.

Book1
	A	B	C	D	E	F	G	H	I
1	Case Court Initials	Case Key	Case Number	Docket Date	Docket Code	Sub Docket Desc Text			Results I WANT
2	S39	177869430	19-1-00687-6	9/21/2022	JTRIAL	BERS) SC2	Contains: JUDGE: SWAN, JEFFERY	7	4
3	S39	177869430	19-1-00687-6	9/21/2022	JTRIAL	(BM) JRY DELIBERATED; VERDICT REACH	Contains: JUDGE: TUTSCH, ELISABETH M	17	3
4	S39	177869430	19-1-00687-6	9/21/2022	JTRIAL	ED; GUILTY CNT 1; GUILTY CNT-2; CRT	Contains: JUDGE: HARTHCOCK, GAYLE M	1	1
5	S39	177869430	19-1-00687-6	9/21/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
6	S39	177869430	19-1-00687-6	9/21/2022	JTRIAL	REPORTED BY J.MOORE (WICKES / CHAM
7	S39	177869430	19-1-00687-6	9/21/2022	JTRIAL	. THNKD JRY AND THEY WERE RELEASED;
8	S39	177869430	19-1-00687-6	9/20/2022	JTRIAL	AN DELIBERATIONS; REPORTED BY J. MO
9	S39	177869430	19-1-00687-6	9/20/2022	JTRIAL	(BM) CRT. READ JURY INSTRUCTIONS; C
10	S39	177869430	19-1-00687-6	9/20/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
11	S39	177869430	19-1-00687-6	9/20/2022	JTRIAL	ORE (WIICKES / CHAMBERS) SC2
12	S39	177869430	19-1-00687-6	9/20/2022	JTRIAL	RT. HRD CLOSING ARGUMETNS; JURY BEG
13	S39	177869430	19-1-00687-6	9/19/2022	JTRIAL	AMBERS) SC2
14	S39	177869430	19-1-00687-6	9/19/2022	JTRIAL	(BM) CRT. HRD TESTMNY; STATE RESTS;
15	S39	177869430	19-1-00687-6	9/19/2022	JTRIAL	CRT. HRD DEF TESTMNY; DEFENSE REST
16	S39	177869430	19-1-00687-6	9/19/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
17	S39	177869430	19-1-00687-6	9/19/2022	JTRIAL	S; REPORTED BY J.MOORE (WICKES / CH
18	S39	177869430	19-1-00687-6	9/16/2022	JTRIAL	(BM) CRT. HRD TESTMNY; REPORTED BY
19	S39	177869430	19-1-00687-6	9/16/2022	JTRIAL	J.MOORE (WICKES / CHAMBERS) SC2
20	S39	177869430	19-1-00687-6	9/16/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
21	S39	177869430	19-1-00687-6	9/15/2022	JTRIAL	(BM) CRT. HRD TESTMNY; REPORTED BY
22	S39	177869430	19-1-00687-6	9/15/2022	JTRIAL	J.MOORE (WICKES / CHAMBERS) SC2
23	S39	177869430	19-1-00687-6	9/15/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
24	S39	177869430	19-1-00687-6	9/14/2022	JTRIAL	(BM) CRT. HRD TESTMNY; REPORTED BY
25	S39	177869430	19-1-00687-6	9/14/2022	JTRIAL	J.MOORE (WICKES / CHAMBERS) SC2
26	S39	177869430	19-1-00687-6	9/14/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
27	S39	177869430	19-1-00687-6	9/13/2022	JTRIAL	ALLNGES; JURY EMPANELLED; REPORTED
28	S39	177869430	19-1-00687-6	9/13/2022	JTRIAL	(BM) CRT. HRD HARDSHIPS; PEREMPT CH
29	S39	177869430	19-1-00687-6	9/13/2022	JTRIAL	BY J.MOORE (WICKES / CHAMBERS) SC2
30	S39	177869430	19-1-00687-6	9/13/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
31	S39	177869430	19-1-00687-6	9/12/2022	JTRIAL	(BM) JURY SELECTION BEGAN; HARDSHIP
32	S39	177869430	19-1-00687-6	9/12/2022	JTRIAL	HRD (WICKES / CHAMBERS) REPORTED B
33	S39	177869430	19-1-00687-6	9/12/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
34	S39	177869430	19-1-00687-6	9/12/2022	JTRIAL	Y J.MOORE; SC2
35	S39	177358804	19-1-00048-7	8/31/2022	JTRIAL	(BM) JURY RESUMED DELIBERATIONS; VE
36	S39	177358804	19-1-00048-7	8/31/2022	JTRIAL	C2
37	S39	177358804	19-1-00048-7	8/31/2022	JTRIAL	J.MOORE; JEREMY CHAMBERS INTERP; S
38	S39	177358804	19-1-00048-7	8/31/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
39	S39	177358804	19-1-00048-7	8/31/2022	JTRIAL	PLUS AGGRIVATERS; SENT 10/12; ORD
40	S39	177358804	19-1-00048-7	8/31/2022	JTRIAL	RDICT REACHED; GUILTY ON ALL COUNTS
41	S39	177358804	19-1-00048-7	8/31/2022	JTRIAL	SIGND (HOLBROOK/OAKLEY) REPORTED BY
42	S39	177358804	19-1-00048-7	8/30/2022	JTRIAL	(BM) CRT. READ JURY INSTRUCTIONS; C
43	S39	177358804	19-1-00048-7	8/30/2022	JTRIAL	DELIBERATIONS (HOLBROOK / OAKLEY)
44	S39	177358804	19-1-00048-7	8/30/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
45	S39	177358804	19-1-00048-7	8/30/2022	JTRIAL	NTERP; SC2
46	S39	177358804	19-1-00048-7	8/30/2022	JTRIAL	REPORTED BY J.MOORE; DORA ORNELAS I
47	S39	177358804	19-1-00048-7	8/30/2022	JTRIAL	RT. HRD CLOSING ARGMNTS; JURY BEGAN
48	S39	177358804	19-1-00048-7	8/29/2022	JTRIAL	AKLEY) REPORTED BY J.MOORE; DORA OR
49	S39	177358804	19-1-00048-7	8/29/2022	JTRIAL	(BM) CRT. HRD TESTMNY (HOLBROOK / O
50	S39	177358804	19-1-00048-7	8/29/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
51	S39	177358804	19-1-00048-7	8/29/2022	JTRIAL	NELAS INTERP; SC2
52	S39	177358804	19-1-00048-7	8/26/2022	JTRIAL	AKLEY) REPORTED BY J. MOORE; INTERP
53	S39	177358804	19-1-00048-7	8/26/2022	JTRIAL	(BM) CRT HRD. TESTMNY (HOLBROOK / O
54	S39	177358804	19-1-00048-7	8/26/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
55	S39	177358804	19-1-00048-7	8/26/2022	JTRIAL	RETED BY DORA ORNELAS; SC2
56	S39	177358804	19-1-00048-7	8/25/2022	JTRIAL	AKLEY) REPORTED BY J. MOORE; INTERP
57	S39	177358804	19-1-00048-7	8/25/2022	JTRIAL	(BM) CRT HRD. TESTMNY (HOLBROOK / O
58	S39	177358804	19-1-00048-7	8/25/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
59	S39	177358804	19-1-00048-7	8/25/2022	JTRIAL	RETED BY DORA ORNELAS SC2
60	S39	177358804	19-1-00048-7	8/24/2022	JTRIAL	(BM) VOIR DIRE WAS HRD; JURY EMPANE
61	S39	177358804	19-1-00048-7	8/24/2022	JTRIAL	EMY CHAMBERS; SC2
62	S39	177358804	19-1-00048-7	8/24/2022	JTRIAL	; INTERPRETED BY DORA ORNELAS & JER
63	S39	177358804	19-1-00048-7	8/24/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
64	S39	177358804	19-1-00048-7	8/24/2022	JTRIAL	LED; CRT. HRD OPENING STAMNTS (HOLB
65	S39	177358804	19-1-00048-7	8/24/2022	JTRIAL	ROOK / OAKLEY) REPORTED BY J. MOORE
66	S39	177358804	19-1-00048-7	8/23/2022	JTRIAL	(BM) JRY SELECTION; PRIVATE INTERVS
67	S39	177358804	19-1-00048-7	8/23/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
68	S39	177358804	19-1-00048-7	8/23/2022	JTRIAL	S CHAVEZ & JEREMY CHAMBERS; SC2
69	S39	177358804	19-1-00048-7	8/23/2022	JTRIAL	TED BY J. MOORE; INTERPRTED BY JESU
70	S39	177358804	19-1-00048-7	8/23/2022	JTRIAL	WERE HRD (HOLBROOK / OAKLEY) REPOR
71	S39	177358804	19-1-00048-7	8/22/2022	JTRIAL	2
72	S39	177358804	19-1-00048-7	8/22/2022	JTRIAL	(BM) JRY SELECTION; HARDSHIP HRD (H
73	S39	177358804	19-1-00048-7	8/22/2022	JTRIAL	(BM) JURY SELECTION BEGAN (HOLBROOK
74	S39	177358804	19-1-00048-7	8/22/2022	JTRIAL	CHAVEZ INTERP; SC2
75	S39	177358804	19-1-00048-7	8/22/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
76	S39	177358804	19-1-00048-7	8/22/2022	JTRIAL	/ OAKLEY) REPORTED BY J.MOORE; J.
77	S39	177358804	19-1-00048-7	8/22/2022	JTRIAL	OLBROOK / OAKLEY) REPORTED BY J. MO
78	S39	177358804	19-1-00048-7	8/22/2022	JTRIAL	ORE; INTERPRTED BY JESUS CHAVEZ; SC
79	S39	179929143	20-1-01217-9	8/5/2022	JTRIAL	ERED; EXHIBITS ENTERED / SWORN TEST
80	S39	179929143	20-1-01217-9	8/5/2022	JTRIAL	FTRSC2)
81	S39	179929143	20-1-01217-9	8/5/2022	JTRIAL	IMONY; ROBERTS/STATE; CASE/DEFENSE;
82	S39	179929143	20-1-01217-9	8/5/2022	JTRIAL	JUDGE: SWAN, JEFFERY
83	S39	179929143	20-1-01217-9	8/5/2022	JTRIAL	JURY TRIAL; VERDICT NOT GUILTYREND
84	S39	179929143	20-1-01217-9	8/5/2022	JTRIAL	(SAR; G/S ORDER ON ACQUITTAL. 4 DAY
85	S39	180779309	21-1-00621-5	6/27/2022	JTRIAL	JUDGE: SWAN, JEFFERY
86	S39	180779309	21-1-00621-5	6/27/2022	JTRIAL	(MM) WRITTEN MINUTES
87	S39	181794709	22-1-00238-2	6/21/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
88	S39	181794709	22-1-00238-2	6/21/2022	JTRIAL	(MM) WRITTEN MINUTES
89	S39	181115956	21-1-01172-3	6/7/2022	JTRIAL	(BM/MM) WRITTEN MINUTES
90	S39	181115956	21-1-01172-3	6/7/2022	JTRIAL	JUDGE: HARTHCOCK, GAYLE M
91	S39	179377494	20-1-00262-9	5/9/2022	JTRIAL	JUDGE: SWAN, JEFFERY
92	S39	179377494	20-1-00262-9	5/9/2022	JTRIAL	(MM) WRITTEN MINUTES
93	S39	176704718	18-1-01653-9	4/18/2022	JTRIAL	(BM) CRT HRD TESTMNY (BARRETT / SCO
94	S39	176704718	18-1-01653-9	4/18/2022	JTRIAL	JUDGE: SWAN, JEFFERY
95	S39	176704718	18-1-01653-9	4/18/2022	JTRIAL	TT) REPORTED BY J.MOORE; SC2
96	S39	176704718	18-1-01653-9	4/15/2022	JTRIAL	(BARRETT / SCOTT) REPORTED BY J.MO
97	S39	176704718	18-1-01653-9	4/15/2022	JTRIAL	(BM) CRT HRD TESTMNY FROM WITNESSES
98	S39	176704718	18-1-01653-9	4/15/2022	JTRIAL	JUDGE: SWAN, JEFFERY
99	S39	176704718	18-1-01653-9	4/15/2022	JTRIAL	ORE; SC2
100	S39	176704718	18-1-01653-9	4/14/2022	JTRIAL	(BARRETT / SCOTT) REPORTED BY J.MO
101	S39	176704718	18-1-01653-9	4/14/2022	JTRIAL	(BM) CRT HRD TESTMNY FROM WITNESSES
102	S39	176704718	18-1-01653-9	4/14/2022	JTRIAL	JUDGE: SWAN, JEFFERY
103	S39	176704718	18-1-01653-9	4/14/2022	JTRIAL	ORE; SC2
104	S39	176704718	18-1-01653-9	4/13/2022	JTRIAL	(BARRETT / SCOTT) REPORTED BY J.MO
105	S39	176704718	18-1-01653-9	4/13/2022	JTRIAL	(BM) CRT HRD TESTMNY FROM WITNESSES
106	S39	176704718	18-1-01653-9	4/13/2022	JTRIAL	JUDGE: SWAN, JEFFERY
107	S39	176704718	18-1-01653-9	4/13/2022	JTRIAL	ORE; SC2
Sheet1

Cell Formulas
Range	Formula
H2	H2	=COUNTIF(F2:F997,"*JUDGE: SWAN, JEFFERY*")
H3	H3	=COUNTIF(F3:F998,"*JUDGE: TUTSCH, ELISABETH M*")
H4	H4	=COUNTIF(F4:F999,"*JUDGE: HARTHCOCK, GAYLE M*")

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I
1	Case Court Initials	Case Key	Case Number	Docket Date	Docket Code	Sub Docket Desc Text
2	S39	177869430	19-1-00687-6	9/21/2022	JTRIAL	BERS) SC2	JUDGE: TUTSCH, ELISABETH M	17	3
3	S39	177869430	19-1-00687-6	9/21/2022	JTRIAL	(BM) JRY DELIBERATED; VERDICT REACH	JUDGE: SWAN, JEFFERY	7	4
4	S39	177869430	19-1-00687-6	9/21/2022	JTRIAL	ED; GUILTY CNT 1; GUILTY CNT-2; CRT	JUDGE: HARTHCOCK, GAYLE M	1	1
5	S39	177869430	19-1-00687-6	9/21/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
6	S39	177869430	19-1-00687-6	9/21/2022	JTRIAL	REPORTED BY J.MOORE (WICKES / CHAM
7	S39	177869430	19-1-00687-6	9/21/2022	JTRIAL	. THNKD JRY AND THEY WERE RELEASED;
8	S39	177869430	19-1-00687-6	9/20/2022	JTRIAL	AN DELIBERATIONS; REPORTED BY J. MO
9	S39	177869430	19-1-00687-6	9/20/2022	JTRIAL	(BM) CRT. READ JURY INSTRUCTIONS; C
10	S39	177869430	19-1-00687-6	9/20/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
11	S39	177869430	19-1-00687-6	9/20/2022	JTRIAL	ORE (WIICKES / CHAMBERS) SC2
12	S39	177869430	19-1-00687-6	9/20/2022	JTRIAL	RT. HRD CLOSING ARGUMETNS; JURY BEG
13	S39	177869430	19-1-00687-6	9/19/2022	JTRIAL	AMBERS) SC2
14	S39	177869430	19-1-00687-6	9/19/2022	JTRIAL	(BM) CRT. HRD TESTMNY; STATE RESTS;
15	S39	177869430	19-1-00687-6	9/19/2022	JTRIAL	CRT. HRD DEF TESTMNY; DEFENSE REST
16	S39	177869430	19-1-00687-6	9/19/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
17	S39	177869430	19-1-00687-6	9/19/2022	JTRIAL	S; REPORTED BY J.MOORE (WICKES / CH
18	S39	177869430	19-1-00687-6	9/16/2022	JTRIAL	(BM) CRT. HRD TESTMNY; REPORTED BY
19	S39	177869430	19-1-00687-6	9/16/2022	JTRIAL	J.MOORE (WICKES / CHAMBERS) SC2
20	S39	177869430	19-1-00687-6	9/16/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
21	S39	177869430	19-1-00687-6	9/15/2022	JTRIAL	(BM) CRT. HRD TESTMNY; REPORTED BY
22	S39	177869430	19-1-00687-6	9/15/2022	JTRIAL	J.MOORE (WICKES / CHAMBERS) SC2
23	S39	177869430	19-1-00687-6	9/15/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
24	S39	177869430	19-1-00687-6	9/14/2022	JTRIAL	(BM) CRT. HRD TESTMNY; REPORTED BY
25	S39	177869430	19-1-00687-6	9/14/2022	JTRIAL	J.MOORE (WICKES / CHAMBERS) SC2
26	S39	177869430	19-1-00687-6	9/14/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
27	S39	177869430	19-1-00687-6	9/13/2022	JTRIAL	ALLNGES; JURY EMPANELLED; REPORTED
28	S39	177869430	19-1-00687-6	9/13/2022	JTRIAL	(BM) CRT. HRD HARDSHIPS; PEREMPT CH
29	S39	177869430	19-1-00687-6	9/13/2022	JTRIAL	BY J.MOORE (WICKES / CHAMBERS) SC2
30	S39	177869430	19-1-00687-6	9/13/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
31	S39	177869430	19-1-00687-6	09/12/2022	JTRIAL	(BM) JURY SELECTION BEGAN; HARDSHIP
32	S39	177869430	19-1-00687-6	09/12/2022	JTRIAL	HRD (WICKES / CHAMBERS) REPORTED B
33	S39	177869430	19-1-00687-6	09/12/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
34	S39	177869430	19-1-00687-6	09/12/2022	JTRIAL	Y J.MOORE; SC2
35	S39	177358804	19-1-00048-7	8/31/2022	JTRIAL	(BM) JURY RESUMED DELIBERATIONS; VE
36	S39	177358804	19-1-00048-7	8/31/2022	JTRIAL	C2
37	S39	177358804	19-1-00048-7	8/31/2022	JTRIAL	J.MOORE; JEREMY CHAMBERS INTERP; S
38	S39	177358804	19-1-00048-7	8/31/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
39	S39	177358804	19-1-00048-7	8/31/2022	JTRIAL	PLUS AGGRIVATERS; SENT 10/12; ORD
40	S39	177358804	19-1-00048-7	8/31/2022	JTRIAL	RDICT REACHED; GUILTY ON ALL COUNTS
41	S39	177358804	19-1-00048-7	8/31/2022	JTRIAL	SIGND (HOLBROOK/OAKLEY) REPORTED BY
42	S39	177358804	19-1-00048-7	8/30/2022	JTRIAL	(BM) CRT. READ JURY INSTRUCTIONS; C
43	S39	177358804	19-1-00048-7	8/30/2022	JTRIAL	DELIBERATIONS (HOLBROOK / OAKLEY)
44	S39	177358804	19-1-00048-7	8/30/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
45	S39	177358804	19-1-00048-7	8/30/2022	JTRIAL	NTERP; SC2
46	S39	177358804	19-1-00048-7	8/30/2022	JTRIAL	REPORTED BY J.MOORE; DORA ORNELAS I
47	S39	177358804	19-1-00048-7	8/30/2022	JTRIAL	RT. HRD CLOSING ARGMNTS; JURY BEGAN
48	S39	177358804	19-1-00048-7	8/29/2022	JTRIAL	AKLEY) REPORTED BY J.MOORE; DORA OR
49	S39	177358804	19-1-00048-7	8/29/2022	JTRIAL	(BM) CRT. HRD TESTMNY (HOLBROOK / O
50	S39	177358804	19-1-00048-7	8/29/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
51	S39	177358804	19-1-00048-7	8/29/2022	JTRIAL	NELAS INTERP; SC2
52	S39	177358804	19-1-00048-7	8/26/2022	JTRIAL	AKLEY) REPORTED BY J. MOORE; INTERP
53	S39	177358804	19-1-00048-7	8/26/2022	JTRIAL	(BM) CRT HRD. TESTMNY (HOLBROOK / O
54	S39	177358804	19-1-00048-7	8/26/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
55	S39	177358804	19-1-00048-7	8/26/2022	JTRIAL	RETED BY DORA ORNELAS; SC2
56	S39	177358804	19-1-00048-7	8/25/2022	JTRIAL	AKLEY) REPORTED BY J. MOORE; INTERP
57	S39	177358804	19-1-00048-7	8/25/2022	JTRIAL	(BM) CRT HRD. TESTMNY (HOLBROOK / O
58	S39	177358804	19-1-00048-7	8/25/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
59	S39	177358804	19-1-00048-7	8/25/2022	JTRIAL	RETED BY DORA ORNELAS SC2
60	S39	177358804	19-1-00048-7	8/24/2022	JTRIAL	(BM) VOIR DIRE WAS HRD; JURY EMPANE
61	S39	177358804	19-1-00048-7	8/24/2022	JTRIAL	EMY CHAMBERS; SC2
62	S39	177358804	19-1-00048-7	8/24/2022	JTRIAL	; INTERPRETED BY DORA ORNELAS & JER
63	S39	177358804	19-1-00048-7	8/24/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
64	S39	177358804	19-1-00048-7	8/24/2022	JTRIAL	LED; CRT. HRD OPENING STAMNTS (HOLB
65	S39	177358804	19-1-00048-7	8/24/2022	JTRIAL	ROOK / OAKLEY) REPORTED BY J. MOORE
66	S39	177358804	19-1-00048-7	8/23/2022	JTRIAL	(BM) JRY SELECTION; PRIVATE INTERVS
67	S39	177358804	19-1-00048-7	8/23/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
68	S39	177358804	19-1-00048-7	8/23/2022	JTRIAL	S CHAVEZ & JEREMY CHAMBERS; SC2
69	S39	177358804	19-1-00048-7	8/23/2022	JTRIAL	TED BY J. MOORE; INTERPRTED BY JESU
70	S39	177358804	19-1-00048-7	8/23/2022	JTRIAL	WERE HRD (HOLBROOK / OAKLEY) REPOR
71	S39	177358804	19-1-00048-7	8/22/2022	JTRIAL	2
72	S39	177358804	19-1-00048-7	8/22/2022	JTRIAL	(BM) JRY SELECTION; HARDSHIP HRD (H
73	S39	177358804	19-1-00048-7	8/22/2022	JTRIAL	(BM) JURY SELECTION BEGAN (HOLBROOK
74	S39	177358804	19-1-00048-7	8/22/2022	JTRIAL	CHAVEZ INTERP; SC2
75	S39	177358804	19-1-00048-7	8/22/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
76	S39	177358804	19-1-00048-7	8/22/2022	JTRIAL	/ OAKLEY) REPORTED BY J.MOORE; J.
77	S39	177358804	19-1-00048-7	8/22/2022	JTRIAL	OLBROOK / OAKLEY) REPORTED BY J. MO
78	S39	177358804	19-1-00048-7	8/22/2022	JTRIAL	ORE; INTERPRTED BY JESUS CHAVEZ; SC
79	S39	179929143	20-1-01217-9	08/05/2022	JTRIAL	ERED; EXHIBITS ENTERED / SWORN TEST
80	S39	179929143	20-1-01217-9	08/05/2022	JTRIAL	FTRSC2)
81	S39	179929143	20-1-01217-9	08/05/2022	JTRIAL	IMONY; ROBERTS/STATE; CASE/DEFENSE;
82	S39	179929143	20-1-01217-9	08/05/2022	JTRIAL	JUDGE: SWAN, JEFFERY
83	S39	179929143	20-1-01217-9	08/05/2022	JTRIAL	JURY TRIAL; VERDICT NOT GUILTYREND
84	S39	179929143	20-1-01217-9	08/05/2022	JTRIAL	(SAR; G/S ORDER ON ACQUITTAL. 4 DAY
85	S39	180779309	21-1-00621-5	6/27/2022	JTRIAL	JUDGE: SWAN, JEFFERY
86	S39	180779309	21-1-00621-5	6/27/2022	JTRIAL	(MM) WRITTEN MINUTES
87	S39	181794709	22-1-00238-2	6/21/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
88	S39	181794709	22-1-00238-2	6/21/2022	JTRIAL	(MM) WRITTEN MINUTES
89	S39	181115956	21-1-01172-3	06/07/2022	JTRIAL	(BM/MM) WRITTEN MINUTES
90	S39	181115956	21-1-01172-3	06/07/2022	JTRIAL	JUDGE: HARTHCOCK, GAYLE M
91	S39	179377494	20-1-00262-9	05/09/2022	JTRIAL	JUDGE: SWAN, JEFFERY
92	S39	179377494	20-1-00262-9	05/09/2022	JTRIAL	(MM) WRITTEN MINUTES
93	S39	176704718	18-1-01653-9	4/18/2022	JTRIAL	(BM) CRT HRD TESTMNY (BARRETT / SCO
94	S39	176704718	18-1-01653-9	4/18/2022	JTRIAL	JUDGE: SWAN, JEFFERY
95	S39	176704718	18-1-01653-9	4/18/2022	JTRIAL	TT) REPORTED BY J.MOORE; SC2
96	S39	176704718	18-1-01653-9	4/15/2022	JTRIAL	(BARRETT / SCOTT) REPORTED BY J.MO
97	S39	176704718	18-1-01653-9	4/15/2022	JTRIAL	(BM) CRT HRD TESTMNY FROM WITNESSES
98	S39	176704718	18-1-01653-9	4/15/2022	JTRIAL	JUDGE: SWAN, JEFFERY
99	S39	176704718	18-1-01653-9	4/15/2022	JTRIAL	ORE; SC2
100	S39	176704718	18-1-01653-9	4/14/2022	JTRIAL	(BARRETT / SCOTT) REPORTED BY J.MO
101	S39	176704718	18-1-01653-9	4/14/2022	JTRIAL	(BM) CRT HRD TESTMNY FROM WITNESSES
102	S39	176704718	18-1-01653-9	4/14/2022	JTRIAL	JUDGE: SWAN, JEFFERY
103	S39	176704718	18-1-01653-9	4/14/2022	JTRIAL	ORE; SC2
104	S39	176704718	18-1-01653-9	4/13/2022	JTRIAL	(BARRETT / SCOTT) REPORTED BY J.MO
105	S39	176704718	18-1-01653-9	4/13/2022	JTRIAL	(BM) CRT HRD TESTMNY FROM WITNESSES
106	S39	176704718	18-1-01653-9	4/13/2022	JTRIAL	JUDGE: SWAN, JEFFERY
107	S39	176704718	18-1-01653-9	4/13/2022	JTRIAL	ORE; SC2
Data

Cell Formulas
Range	Formula
G2:G4	G2	=UNIQUE(FILTER(F2:F107,LEFT(F2:F107,5)="judge"))
H2:H4	H2	=COUNTIF(F:F,G2)
I2:I4	I2	=COUNT(UNIQUE(FILTER($B$2:$B$1000,$F$2:$F$1000=G2)))
Dynamic array formulas.

 

[alansidman]

Power Query Solution

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"Sub Docket Desc Text"}, {{"Count", each Table.RowCount(_), Int64.Type}})
in
    #"Grouped Rows"

Book5
	A	B	C	D	E	F	G	H	I
1	Case Court Initials	Case Key	Case Number	Docket Date	Docket Code	Sub Docket Desc Text		Sub Docket Desc Text	Count
2	S39	177869430	19-1-00687-6	9/21/2022	JTRIAL	BERS) SC2		BERS) SC2	1
3	S39	177869430	19-1-00687-6	9/21/2022	JTRIAL	(BM) JRY DELIBERATED; VERDICT REACH		(BM) JRY DELIBERATED; VERDICT REACH	1
4	S39	177869430	19-1-00687-6	9/21/2022	JTRIAL	ED; GUILTY CNT 1; GUILTY CNT-2; CRT		ED; GUILTY CNT 1; GUILTY CNT-2; CRT	1
5	S39	177869430	19-1-00687-6	9/21/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M		JUDGE: TUTSCH, ELISABETH M	17
6	S39	177869430	19-1-00687-6	9/21/2022	JTRIAL	REPORTED BY J.MOORE (WICKES / CHAM		REPORTED BY J.MOORE (WICKES / CHAM	1
7	S39	177869430	19-1-00687-6	9/21/2022	JTRIAL	. THNKD JRY AND THEY WERE RELEASED;		. THNKD JRY AND THEY WERE RELEASED;	1
8	S39	177869430	19-1-00687-6	9/20/2022	JTRIAL	AN DELIBERATIONS; REPORTED BY J. MO		AN DELIBERATIONS; REPORTED BY J. MO	1
9	S39	177869430	19-1-00687-6	9/20/2022	JTRIAL	(BM) CRT. READ JURY INSTRUCTIONS; C		(BM) CRT. READ JURY INSTRUCTIONS; C	2
10	S39	177869430	19-1-00687-6	9/20/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M		ORE (WIICKES / CHAMBERS) SC2	1
11	S39	177869430	19-1-00687-6	9/20/2022	JTRIAL	ORE (WIICKES / CHAMBERS) SC2		RT. HRD CLOSING ARGUMETNS; JURY BEG	1
12	S39	177869430	19-1-00687-6	9/20/2022	JTRIAL	RT. HRD CLOSING ARGUMETNS; JURY BEG		AMBERS) SC2	1
13	S39	177869430	19-1-00687-6	9/19/2022	JTRIAL	AMBERS) SC2		(BM) CRT. HRD TESTMNY; STATE RESTS;	1
14	S39	177869430	19-1-00687-6	9/19/2022	JTRIAL	(BM) CRT. HRD TESTMNY; STATE RESTS;		CRT. HRD DEF TESTMNY; DEFENSE REST	1
15	S39	177869430	19-1-00687-6	9/19/2022	JTRIAL	CRT. HRD DEF TESTMNY; DEFENSE REST		S; REPORTED BY J.MOORE (WICKES / CH	1
16	S39	177869430	19-1-00687-6	9/19/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M		(BM) CRT. HRD TESTMNY; REPORTED BY	3
17	S39	177869430	19-1-00687-6	9/19/2022	JTRIAL	S; REPORTED BY J.MOORE (WICKES / CH		J.MOORE (WICKES / CHAMBERS) SC2	3
18	S39	177869430	19-1-00687-6	9/16/2022	JTRIAL	(BM) CRT. HRD TESTMNY; REPORTED BY		ALLNGES; JURY EMPANELLED; REPORTED	1
19	S39	177869430	19-1-00687-6	9/16/2022	JTRIAL	J.MOORE (WICKES / CHAMBERS) SC2		(BM) CRT. HRD HARDSHIPS; PEREMPT CH	1
20	S39	177869430	19-1-00687-6	9/16/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M		BY J.MOORE (WICKES / CHAMBERS) SC2	1
21	S39	177869430	19-1-00687-6	9/15/2022	JTRIAL	(BM) CRT. HRD TESTMNY; REPORTED BY		(BM) JURY SELECTION BEGAN; HARDSHIP	1
22	S39	177869430	19-1-00687-6	9/15/2022	JTRIAL	J.MOORE (WICKES / CHAMBERS) SC2		HRD (WICKES / CHAMBERS) REPORTED B	1
23	S39	177869430	19-1-00687-6	9/15/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M		Y J.MOORE; SC2	1
24	S39	177869430	19-1-00687-6	9/14/2022	JTRIAL	(BM) CRT. HRD TESTMNY; REPORTED BY		(BM) JURY RESUMED DELIBERATIONS; VE	1
25	S39	177869430	19-1-00687-6	9/14/2022	JTRIAL	J.MOORE (WICKES / CHAMBERS) SC2		C2	1
26	S39	177869430	19-1-00687-6	9/14/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M		J.MOORE; JEREMY CHAMBERS INTERP; S	1
27	S39	177869430	19-1-00687-6	9/13/2022	JTRIAL	ALLNGES; JURY EMPANELLED; REPORTED		PLUS AGGRIVATERS; SENT 10/12; ORD	1
28	S39	177869430	19-1-00687-6	9/13/2022	JTRIAL	(BM) CRT. HRD HARDSHIPS; PEREMPT CH		RDICT REACHED; GUILTY ON ALL COUNTS	1
29	S39	177869430	19-1-00687-6	9/13/2022	JTRIAL	BY J.MOORE (WICKES / CHAMBERS) SC2		SIGND (HOLBROOK/OAKLEY) REPORTED BY	1
30	S39	177869430	19-1-00687-6	9/13/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M		DELIBERATIONS (HOLBROOK / OAKLEY)	1
31	S39	177869430	19-1-00687-6	9/12/2022	JTRIAL	(BM) JURY SELECTION BEGAN; HARDSHIP		NTERP; SC2	1
32	S39	177869430	19-1-00687-6	9/12/2022	JTRIAL	HRD (WICKES / CHAMBERS) REPORTED B		REPORTED BY J.MOORE; DORA ORNELAS I	1
33	S39	177869430	19-1-00687-6	9/12/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M		RT. HRD CLOSING ARGMNTS; JURY BEGAN	1
34	S39	177869430	19-1-00687-6	9/12/2022	JTRIAL	Y J.MOORE; SC2		AKLEY) REPORTED BY J.MOORE; DORA OR	1
35	S39	177358804	19-1-00048-7	8/31/2022	JTRIAL	(BM) JURY RESUMED DELIBERATIONS; VE		(BM) CRT. HRD TESTMNY (HOLBROOK / O	1
36	S39	177358804	19-1-00048-7	8/31/2022	JTRIAL	C2		NELAS INTERP; SC2	1
37	S39	177358804	19-1-00048-7	8/31/2022	JTRIAL	J.MOORE; JEREMY CHAMBERS INTERP; S		AKLEY) REPORTED BY J. MOORE; INTERP	2
38	S39	177358804	19-1-00048-7	8/31/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M		(BM) CRT HRD. TESTMNY (HOLBROOK / O	2
39	S39	177358804	19-1-00048-7	8/31/2022	JTRIAL	PLUS AGGRIVATERS; SENT 10/12; ORD		RETED BY DORA ORNELAS; SC2	1
40	S39	177358804	19-1-00048-7	8/31/2022	JTRIAL	RDICT REACHED; GUILTY ON ALL COUNTS		RETED BY DORA ORNELAS SC2	1
41	S39	177358804	19-1-00048-7	8/31/2022	JTRIAL	SIGND (HOLBROOK/OAKLEY) REPORTED BY		(BM) VOIR DIRE WAS HRD; JURY EMPANE	1
42	S39	177358804	19-1-00048-7	8/30/2022	JTRIAL	(BM) CRT. READ JURY INSTRUCTIONS; C		EMY CHAMBERS; SC2	1
43	S39	177358804	19-1-00048-7	8/30/2022	JTRIAL	DELIBERATIONS (HOLBROOK / OAKLEY)		; INTERPRETED BY DORA ORNELAS & JER	1
44	S39	177358804	19-1-00048-7	8/30/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M		LED; CRT. HRD OPENING STAMNTS (HOLB	1
45	S39	177358804	19-1-00048-7	8/30/2022	JTRIAL	NTERP; SC2		ROOK / OAKLEY) REPORTED BY J. MOORE	1
46	S39	177358804	19-1-00048-7	8/30/2022	JTRIAL	REPORTED BY J.MOORE; DORA ORNELAS I		(BM) JRY SELECTION; PRIVATE INTERVS	1
47	S39	177358804	19-1-00048-7	8/30/2022	JTRIAL	RT. HRD CLOSING ARGMNTS; JURY BEGAN		S CHAVEZ & JEREMY CHAMBERS; SC2	1
48	S39	177358804	19-1-00048-7	8/29/2022	JTRIAL	AKLEY) REPORTED BY J.MOORE; DORA OR		TED BY J. MOORE; INTERPRTED BY JESU	1
49	S39	177358804	19-1-00048-7	8/29/2022	JTRIAL	(BM) CRT. HRD TESTMNY (HOLBROOK / O		WERE HRD (HOLBROOK / OAKLEY) REPOR	1
50	S39	177358804	19-1-00048-7	8/29/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M		2	1
51	S39	177358804	19-1-00048-7	8/29/2022	JTRIAL	NELAS INTERP; SC2		(BM) JRY SELECTION; HARDSHIP HRD (H	1
52	S39	177358804	19-1-00048-7	8/26/2022	JTRIAL	AKLEY) REPORTED BY J. MOORE; INTERP		(BM) JURY SELECTION BEGAN (HOLBROOK	1
53	S39	177358804	19-1-00048-7	8/26/2022	JTRIAL	(BM) CRT HRD. TESTMNY (HOLBROOK / O		CHAVEZ INTERP; SC2	1
54	S39	177358804	19-1-00048-7	8/26/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M		/ OAKLEY) REPORTED BY J.MOORE; J.	1
55	S39	177358804	19-1-00048-7	8/26/2022	JTRIAL	RETED BY DORA ORNELAS; SC2		OLBROOK / OAKLEY) REPORTED BY J. MO	1
56	S39	177358804	19-1-00048-7	8/25/2022	JTRIAL	AKLEY) REPORTED BY J. MOORE; INTERP		ORE; INTERPRTED BY JESUS CHAVEZ; SC	1
57	S39	177358804	19-1-00048-7	8/25/2022	JTRIAL	(BM) CRT HRD. TESTMNY (HOLBROOK / O		ERED; EXHIBITS ENTERED / SWORN TEST	1
58	S39	177358804	19-1-00048-7	8/25/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M		FTRSC2)	1
59	S39	177358804	19-1-00048-7	8/25/2022	JTRIAL	RETED BY DORA ORNELAS SC2		IMONY; ROBERTS/STATE; CASE/DEFENSE;	1
60	S39	177358804	19-1-00048-7	8/24/2022	JTRIAL	(BM) VOIR DIRE WAS HRD; JURY EMPANE		JUDGE: SWAN, JEFFERY	7
61	S39	177358804	19-1-00048-7	8/24/2022	JTRIAL	EMY CHAMBERS; SC2		JURY TRIAL; VERDICT NOT GUILTYREND	1
62	S39	177358804	19-1-00048-7	8/24/2022	JTRIAL	; INTERPRETED BY DORA ORNELAS & JER		(SAR; G/S ORDER ON ACQUITTAL. 4 DAY	1
63	S39	177358804	19-1-00048-7	8/24/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M		(MM) WRITTEN MINUTES	3
64	S39	177358804	19-1-00048-7	8/24/2022	JTRIAL	LED; CRT. HRD OPENING STAMNTS (HOLB		(BM/MM) WRITTEN MINUTES	1
65	S39	177358804	19-1-00048-7	8/24/2022	JTRIAL	ROOK / OAKLEY) REPORTED BY J. MOORE		JUDGE: HARTHCOCK, GAYLE M	1
66	S39	177358804	19-1-00048-7	8/23/2022	JTRIAL	(BM) JRY SELECTION; PRIVATE INTERVS		(BM) CRT HRD TESTMNY (BARRETT / SCO	1
67	S39	177358804	19-1-00048-7	8/23/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M		TT) REPORTED BY J.MOORE; SC2	1
68	S39	177358804	19-1-00048-7	8/23/2022	JTRIAL	S CHAVEZ & JEREMY CHAMBERS; SC2		(BARRETT / SCOTT) REPORTED BY J.MO	3
69	S39	177358804	19-1-00048-7	8/23/2022	JTRIAL	TED BY J. MOORE; INTERPRTED BY JESU		(BM) CRT HRD TESTMNY FROM WITNESSES	3
70	S39	177358804	19-1-00048-7	8/23/2022	JTRIAL	WERE HRD (HOLBROOK / OAKLEY) REPOR		ORE; SC2	3
71	S39	177358804	19-1-00048-7	8/22/2022	JTRIAL	2
72	S39	177358804	19-1-00048-7	8/22/2022	JTRIAL	(BM) JRY SELECTION; HARDSHIP HRD (H
73	S39	177358804	19-1-00048-7	8/22/2022	JTRIAL	(BM) JURY SELECTION BEGAN (HOLBROOK
74	S39	177358804	19-1-00048-7	8/22/2022	JTRIAL	CHAVEZ INTERP; SC2
75	S39	177358804	19-1-00048-7	8/22/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
76	S39	177358804	19-1-00048-7	8/22/2022	JTRIAL	/ OAKLEY) REPORTED BY J.MOORE; J.
77	S39	177358804	19-1-00048-7	8/22/2022	JTRIAL	OLBROOK / OAKLEY) REPORTED BY J. MO
78	S39	177358804	19-1-00048-7	8/22/2022	JTRIAL	ORE; INTERPRTED BY JESUS CHAVEZ; SC
79	S39	179929143	20-1-01217-9	8/5/2022	JTRIAL	ERED; EXHIBITS ENTERED / SWORN TEST
80	S39	179929143	20-1-01217-9	8/5/2022	JTRIAL	FTRSC2)
81	S39	179929143	20-1-01217-9	8/5/2022	JTRIAL	IMONY; ROBERTS/STATE; CASE/DEFENSE;
82	S39	179929143	20-1-01217-9	8/5/2022	JTRIAL	JUDGE: SWAN, JEFFERY
83	S39	179929143	20-1-01217-9	8/5/2022	JTRIAL	JURY TRIAL; VERDICT NOT GUILTYREND
84	S39	179929143	20-1-01217-9	8/5/2022	JTRIAL	(SAR; G/S ORDER ON ACQUITTAL. 4 DAY
85	S39	180779309	21-1-00621-5	6/27/2022	JTRIAL	JUDGE: SWAN, JEFFERY
86	S39	180779309	21-1-00621-5	6/27/2022	JTRIAL	(MM) WRITTEN MINUTES
87	S39	181794709	22-1-00238-2	6/21/2022	JTRIAL	JUDGE: TUTSCH, ELISABETH M
88	S39	181794709	22-1-00238-2	6/21/2022	JTRIAL	(MM) WRITTEN MINUTES
89	S39	181115956	21-1-01172-3	6/7/2022	JTRIAL	(BM/MM) WRITTEN MINUTES
90	S39	181115956	21-1-01172-3	6/7/2022	JTRIAL	JUDGE: HARTHCOCK, GAYLE M
91	S39	179377494	20-1-00262-9	5/9/2022	JTRIAL	JUDGE: SWAN, JEFFERY
92	S39	179377494	20-1-00262-9	5/9/2022	JTRIAL	(MM) WRITTEN MINUTES
93	S39	176704718	18-1-01653-9	4/18/2022	JTRIAL	(BM) CRT HRD TESTMNY (BARRETT / SCO
94	S39	176704718	18-1-01653-9	4/18/2022	JTRIAL	JUDGE: SWAN, JEFFERY
95	S39	176704718	18-1-01653-9	4/18/2022	JTRIAL	TT) REPORTED BY J.MOORE; SC2
96	S39	176704718	18-1-01653-9	4/15/2022	JTRIAL	(BARRETT / SCOTT) REPORTED BY J.MO
97	S39	176704718	18-1-01653-9	4/15/2022	JTRIAL	(BM) CRT HRD TESTMNY FROM WITNESSES
98	S39	176704718	18-1-01653-9	4/15/2022	JTRIAL	JUDGE: SWAN, JEFFERY
99	S39	176704718	18-1-01653-9	4/15/2022	JTRIAL	ORE; SC2
100	S39	176704718	18-1-01653-9	4/14/2022	JTRIAL	(BARRETT / SCOTT) REPORTED BY J.MO
101	S39	176704718	18-1-01653-9	4/14/2022	JTRIAL	(BM) CRT HRD TESTMNY FROM WITNESSES
102	S39	176704718	18-1-01653-9	4/14/2022	JTRIAL	JUDGE: SWAN, JEFFERY
103	S39	176704718	18-1-01653-9	4/14/2022	JTRIAL	ORE; SC2
104	S39	176704718	18-1-01653-9	4/13/2022	JTRIAL	(BARRETT / SCOTT) REPORTED BY J.MO
105	S39	176704718	18-1-01653-9	4/13/2022	JTRIAL	(BM) CRT HRD TESTMNY FROM WITNESSES
106	S39	176704718	18-1-01653-9	4/13/2022	JTRIAL	JUDGE: SWAN, JEFFERY
107	S39	176704718	18-1-01653-9	4/13/2022	JTRIAL	ORE; SC2
Sheet1

 

[keef2]

another way:

Book1
	H	I	J	K	L	M	N	O	P
1	Case Court Initials	Case Key	Case Number	Docket Date	Docket Code	Sub Docket Desc Text		Judge
2	S39	177869430	19-1-00687-6	44825	JTRIAL	JUDGE: TUTSCH, ELISABETH M		JUDGE: TUTSCH, ELISABETH M	3
3	S39	177869430	19-1-00687-6	44824	JTRIAL	JUDGE: TUTSCH, ELISABETH M		JUDGE: SWAN, JEFFERY	4
4	S39	177869430	19-1-00687-6	44823	JTRIAL	JUDGE: TUTSCH, ELISABETH M		JUDGE: HARTHCOCK, GAYLE M	1
5	S39	177869430	19-1-00687-6	44820	JTRIAL	JUDGE: TUTSCH, ELISABETH M
6	S39	177869430	19-1-00687-6	44819	JTRIAL	JUDGE: TUTSCH, ELISABETH M
7	S39	177869430	19-1-00687-6	44818	JTRIAL	JUDGE: TUTSCH, ELISABETH M
8	S39	177869430	19-1-00687-6	44817	JTRIAL	JUDGE: TUTSCH, ELISABETH M
9	S39	177869430	19-1-00687-6	44816	JTRIAL	JUDGE: TUTSCH, ELISABETH M
10	S39	177358804	19-1-00048-7	44804	JTRIAL	JUDGE: TUTSCH, ELISABETH M
11	S39	177358804	19-1-00048-7	44803	JTRIAL	JUDGE: TUTSCH, ELISABETH M
12	S39	177358804	19-1-00048-7	44802	JTRIAL	JUDGE: TUTSCH, ELISABETH M
13	S39	177358804	19-1-00048-7	44799	JTRIAL	JUDGE: TUTSCH, ELISABETH M
14	S39	177358804	19-1-00048-7	44798	JTRIAL	JUDGE: TUTSCH, ELISABETH M
15	S39	177358804	19-1-00048-7	44797	JTRIAL	JUDGE: TUTSCH, ELISABETH M
16	S39	177358804	19-1-00048-7	44796	JTRIAL	JUDGE: TUTSCH, ELISABETH M
17	S39	177358804	19-1-00048-7	44795	JTRIAL	JUDGE: TUTSCH, ELISABETH M
18	S39	179929143	20-1-01217-9	44778	JTRIAL	JUDGE: SWAN, JEFFERY
19	S39	180779309	21-1-00621-5	44739	JTRIAL	JUDGE: SWAN, JEFFERY
20	S39	181794709	22-1-00238-2	44733	JTRIAL	JUDGE: TUTSCH, ELISABETH M
21	S39	181115956	21-1-01172-3	44719	JTRIAL	JUDGE: HARTHCOCK, GAYLE M
22	S39	179377494	20-1-00262-9	44690	JTRIAL	JUDGE: SWAN, JEFFERY
23	S39	176704718	18-1-01653-9	44669	JTRIAL	JUDGE: SWAN, JEFFERY
24	S39	176704718	18-1-01653-9	44666	JTRIAL	JUDGE: SWAN, JEFFERY
25	S39	176704718	18-1-01653-9	44665	JTRIAL	JUDGE: SWAN, JEFFERY
26	S39	176704718	18-1-01653-9	44664	JTRIAL	JUDGE: SWAN, JEFFERY
Sheet1

Cell Formulas
Range	Formula
H2:M26	H2	=FILTER(A2:F107,ISNUMBER(SEARCH("*Judge*",F2:F107)))
O2:O4	O2	=UNIQUE(FILTER(F2:F107,ISNUMBER(SEARCH("Judge",F2:F107))*COUNTIF(F2:F107,F2:F107)))
P2:P4	P2	=SUMPRODUCT(($M$2:$M$26=$O2)*(($I$2:$I$26<>"")/COUNTIF($I$2:$I$26,$I$2:$I$26&"")))
Dynamic array formulas.

 

[Ev1lZer0]

It took me a minute to figure out how to apply this to my sheet as blank cells in Column F were throwing me off. Additionally, you had only accounted for the first 1000 rows as opposed to all 22,525 rows. after I figured that out, it was clear!

 

[Fluff]

Glad we could help & thanks for the feedback.