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]{"data-align":"none","data-size":"full","title":"Baseball 1.jpg","data-attachmentid":1205332}[/ATTACH]