Actually, it didn't just work...it showed me I had quite a few errors in another column, so a double thank you is in order.
Posts by Alix James


Brilliant! Thank you, exactly what I was looking for. Will have to do some reading on Frequency.
The generosity of this community never ceases to amaze me.
Thanks!

Oops, forgot my manners please see the attached Baseball Example.xlsm
In baseball, a team will travel to a city, play a number of games, then move on to another city. [TABLE="border: 0, cellpadding: 0, cellspacing: 0"]
[tr]
[/tr]
[TD="width: 45"]Year[/TD]
[TD="width: 32"]Gm#[/TD]
[TD="width: 158"]Date[/TD]
[TD="width: 36"]M[/TD]
[TD="width: 26"]D[/TD]
[TD="width: 32"]Loc[/TD]
[TD="width: 68"]Opp[/TD]
[TD="width: 113"]Series[/TD]
[tr]
[td]
[TD="align: right"]2014[/TD]
[TD="align: right"]1[/TD]
[TD="align: left"]Monday, Mar 31[/TD]
[TD="align: left"]Mar[/TD]
[TD="align: right"]31[/TD]A
[/td]
[td]TBR
[/td]
[td]2014 TBR A
[/td]
[/tr]
[tr]
[td]
[TD="align: right"]2014[/TD]
[TD="align: right"]2[/TD]
[TD="align: left"]Tuesday, Apr 1[/TD]
[TD="align: left"]Apr[/TD]
[TD="align: right"]1[/TD]A
[/td]
[td]TBR
[/td]
[td]2014 TBR A
[/td]
[/tr]
[tr]
[td]
[TD="align: right"]2014[/TD]
[TD="align: right"]3[/TD]
[TD="align: left"]Wednesday, Apr 2[/TD]
[TD="align: left"]Apr[/TD]
[TD="align: right"]2[/TD]A
[/td]
[td]TBR
[/td]
[td]2014 TBR A
[/td]
[/tr]
[tr]
[td]
[TD="align: right"]2014[/TD]
[TD="align: right"]4[/TD]
[TD="align: left"]Thursday, Apr 3[/TD]
[TD="align: left"]Apr[/TD]
[TD="align: right"]3[/TD]A
[/td]
[td]TBR
[/td]
[td]2014 TBR A
[/td]
[/tr]
[tr]
[td]
[TD="align: right"]2014[/TD]
[TD="align: right"]94[/TD]
[TD="align: left"]Friday, Jul 11[/TD]
[TD="align: left"]Jul[/TD]
[TD="align: right"]11[/TD]A
[/td]
[td]TBR
[/td]
[td]2014 TBR A
[/td]
[/tr]
[tr]
[td]
[TD="align: right"]2014[/TD]
[TD="align: right"]95[/TD]
[TD="align: left"]Saturday, Jul 12[/TD]
[TD="align: left"]Jul[/TD]
[TD="align: right"]12[/TD]A
[/td]
[td]TBR
[/td]
[td]2014 TBR A
[/td]
[/tr]
[tr]
[td]
[TD="align: right"]2014[/TD]
[TD="align: right"]96[/TD]
[TD="align: left"]Sunday, Jul 13[/TD]
[TD="align: left"]Jul[/TD]
[TD="align: right"]13[/TD]A
[/td]
[td]TBR
[/td]
[td]2014 TBR A
[/td]
[/tr]
[tr]
[td]
[TD="align: right"]2014[/TD]
[TD="align: right"]137[/TD]
[TD="align: left"]Tuesday, Sep 2[/TD]
[TD="align: left"]Sep[/TD]
[TD="align: right"]2[/TD]A
[/td]
[td]TBR
[/td]
[td]2014 TBR A
[/td]
[/tr]
[tr]
[td]
[TD="align: right"]2014[/TD]
[TD="align: right"]138[/TD]
[TD="align: left"]Wednesday, Sep 3[/TD]
[TD="align: left"]Sep[/TD]
[TD="align: right"]3[/TD]A
[/td]
[td]TBR
[/td]
[td]2014 TBR A
[/td]
[/tr]
[tr]
[td]
[TD="align: right"]2014[/TD]
[TD="align: right"]139[/TD]
[TD="align: left"]Thursday, Sep 4[/TD]
[TD="align: left"]Sep[/TD]
[TD="align: right"]4[/TD]A
[/td]
[td]TBR
[/td]
[td]2014 TBR A
[/td]
[/tr]
[/TABLE]
In this case, the Blue Jays traveled to Tampa Bay on March 31st, played a game four games over four days, then left. So its:2014 (Year)
TBR (Tampa Bay Rays)
A (Away)They returned to Tampa Bay on Friday July 11 to play three games, then on September 2 to play three games.
I am looking for a formula (this spreadsheet has data since 1977 can't manually do it easily) that will provide me with something like:
2014 TBR A #1 (for Mar 31 to Apr 3)
2014 TBR A #2 (Jul 11 to 13)
2014 TBR A #3 (Sep 2 to Sep 4)Problems I'm having are:
 Series can be 1, 2, 3, or 5 games
 Dates are mostly, but not always, consecutive
Thanks.

I have a spreadsheet with baseball scores. I can't get my head around how to count individual series. Column L has most of what I need, but the games April 9 to 11 are series 1, games August 27 to 29 series 2, etc.
What sort of formula (helper columns are ok) would I need to look at cell L660, determine that its the same series as L661 and L662, but different than series in L780.
Thanks.
[ATTACH=JSON]{"dataalign":"none","datasize":"full","title":"Baseball 1.jpg","dataattachmentid":1205332}[/ATTACH]