Counting the number of Baseball series per team

[Stephen_IV]

In baseball, a series refers to two or more consecutive games played between the same two teams. I would like to count per team the number of series played per year. For example BOS there were 6, CHW there were 2 etc, any help would be appreciated!!

Book1 A B C D E 1 Tm Opp Examples 2 NYY BOS BOS 6 3 NYY BOS CHW 2 4 NYY BOS CIN 1 5 NYY TOR 6 NYY TOR 7 NYY TOR 8 NYY TOR 9 NYY BAL 10 NYY BAL 11 NYY BAL 12 NYY DET 13 NYY DET 14 NYY DET 15 NYY CLE 16 NYY CLE 17 NYY CLE 18 NYY BAL 19 NYY BAL 20 NYY BAL 21 NYY KCR 22 NYY KCR 23 NYY KCR 24 NYY TOR 25 NYY TOR 26 NYY TOR 27 NYY TEX 28 NYY TEX 29 NYY TEX 30 NYY TOR 31 NYY TOR 32 NYY CHW 33 NYY CHW 34 NYY CHW 35 NYY CHW 36 NYY BAL 37 NYY BAL 38 NYY BAL 39 NYY BAL 40 NYY CHW 41 NYY CHW 42 NYY CHW 43 NYY BAL 44 NYY BAL 45 NYY BAL 46 NYY TBR 47 NYY TBR 48 NYY TBR 49 NYY TBR 50 NYY LAA 51 NYY LAA 52 NYY LAA 53 NYY DET 54 NYY DET 55 NYY DET 56 NYY MIN 57 NYY MIN 58 NYY MIN 59 NYY CHC 60 NYY CHC 61 NYY CHC 62 NYY TBR 63 NYY TBR 64 NYY TBR 65 NYY TOR 66 NYY TOR 67 NYY TOR 68 NYY TBR 69 NYY TBR 70 NYY TBR 71 NYY HOU 72 NYY HOU 73 NYY HOU 74 NYY HOU 75 NYY OAK 76 NYY OAK 77 NYY OAK 78 NYY HOU 79 NYY CLE 80 NYY CLE 81 NYY CLE 82 NYY PIT 83 NYY PIT 84 NYY BOS 85 NYY BOS 86 NYY BOS 87 NYY BOS 88 NYY CIN 89 NYY CIN 90 NYY CIN 91 NYY BOS 92 NYY BOS 93 NYY BOS 94 NYY HOU 95 NYY HOU 96 NYY BAL 97 NYY BAL 98 NYY BAL 99 NYY NYM 100 NYY NYM 101 NYY KCR 102 NYY KCR 103 NYY KCR 104 NYY KCR 105 NYY SEA 106 NYY SEA 107 NYY SEA 108 NYY STL 109 NYY STL 110 NYY STL 111 NYY SEA 112 NYY SEA 113 NYY SEA 114 NYY BOS 115 NYY BOS 116 NYY BOS 117 NYY TBR 118 NYY TBR 119 NYY TBR 120 NYY TOR 121 NYY TOR 122 NYY TOR 123 NYY TOR 124 NYY NYM 125 NYY NYM 126 NYY OAK 127 NYY OAK 128 NYY OAK 129 NYY OAK 130 NYY LAA 131 NYY LAA 132 NYY LAA 133 NYY TBR 134 NYY TBR 135 NYY TBR 136 NYY MIN 137 NYY MIN 138 NYY MIN 139 NYY MIN 140 NYY TBR 141 NYY TBR 142 NYY TBR 143 NYY BOS 144 NYY BOS 145 NYY MIL 146 NYY MIL 147 NYY MIL 148 NYY PIT 149 NYY PIT 150 NYY BOS 151 NYY BOS 152 NYY BOS 153 NYY BOS 154 NYY TOR 155 NYY TOR 156 NYY TOR 157 NYY BAL 158 NYY BAL 159 NYY BAL 160 NYY TEX 161 NYY TEX 162 NYY TEX 163 NYY TEX Sheet2

 

[James006]

Hi,
For cell E2, you can test

=SUM(IF(FREQUENCY(IF($B$2:$B$163=D2,ROW($B$2:$B$163)),IF($B$2:$B$163<>D2,ROW($B$2:$B$163)))>=2,1,0))

 

[Stephen_IV]

James006!!! Perfect!!! Exactly what I needed! Thanks so much!

 

[James006]

You are welcome