3 wins in a row

methody · May 1, 2011

Hello there

I have a list of sports fixtures eg Man Utd v Arsenal, Chelsea v spurs etc one below the other. I enter the scores eg Man Utd 0 v 1 Arsenal.

I am looking for a formula this will indicate when a team has won 4 matches in a row. So that as I enter all the results once the 4th consecutive wins for a particular team occurs an X appears to the right of that team indicating a run of 4.

The difficult is that team names may appear on the left and the right.

I would also want a new chain or run to start after the first 4 so that if there were 5 consecutive wins and X would not appear beside the 5th win.

A starting point might be to have a basic If formula to the left or right of each fixture indicating W or L but that's as far far as I can go.

thanks

methody · May 2, 2011

Hello Jason
For these matches there won't be draws but any loss means the streak starts again.

Aladin
In your example there would be X's :
In the 8th match down for FAD ater the 1-0 nil win over ZAD
The other X you have for NAD is right.

Aladin Akyurek · May 2, 2011

methody said:
Hello Jason
For these matches there won't be draws but any loss means the streak starts again.

Aladin
In your example there would be X's :
In the 8th match down for FAD ater the 1-0 nil win over ZAD
The other X you have for NAD is right.

Control+shift+enter, not just enter:

Rich (BB code):

=IF(COUNTIF($E$3:E3,E3)>=$G$1,
    IF(MAX(FREQUENCY(IF($E$3:E3=E3,ROW($E$3:E3)),IF(LEN($E$3:E3),
      IF($E$3:E3<>E3,ROW($E$3:E3)))))=$G$1,"X",""),"")

Needs some more testing though...

methody · May 2, 2011

Hello aladin
close but still not right.
The main problem is still the fact that it does not register an X if
team A plays in Match 1 and wins
does not play in Match 2
team A plays in Match 3 and wins
team A plays in Match 4 and wins.

The other scenarios that isn't covered is if team A won six games in a row there should be an X after the 3rd and an X after the 6th.

I appreciate that it' s a tricky one - it may not be possible - but you are getting closer than I ever will.

thanks

Aladin Akyurek · May 2, 2011

methody said:
Hello aladin
close but still not right.
The main problem is still the fact that it does not register an X if
team A plays in Match 1 and wins
does not play in Match 2
team A plays in Match 3 and wins
team A plays in Match 4 and wins.

The other scenarios that isn't covered is if team A won six games in a row there should be an X after the 3rd and an X after the 6th.

I appreciate that it' s a tricky one - it may not be possible - but you are getting closer than I ever will.

thanks

Now it's about time that you post a small sample with nesessary variation together with the desired flag points.

methody · May 2, 2011

I'm trying my best but Colo site no longer available. I don't seems to have access t another version that is available. Any ideas?

jasonb75 · May 2, 2011

Methody, does this look right to you so far?

Aladin, can you help with this, I can't figure out the last part.

If you look at the formula in J2, as it is filled down, the MATCH() function needs to find the last exact match in the range, not the first.

Also, I used IFERROR to reduce changes to the formula in testing, but I believe that the OP is using excel 2003.

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 75px"><COL style="WIDTH: 82px"><COL style="WIDTH: 82px"><COL style="WIDTH: 39px"><COL style="WIDTH: 39px"><COL style="WIDTH: 29px"><COL style="WIDTH: 82px"><COL style="WIDTH: 82px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD>Date</TD><TD>HomeTeam</TD><TD>AwayTeam</TD><TD>FTHG</TD><TD>FTAG</TD><TD>FTR</TD><TD>Winner</TD><TD>Loser</TD><TD>3 Streak</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: right">14/08/2010</TD><TD>Aston Villa</TD><TD>West Ham</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>Aston Villa</TD><TD>West Ham</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: right">14/08/2010</TD><TD>Blackburn</TD><TD>Everton</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>Blackburn</TD><TD>Everton</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: right">14/08/2010</TD><TD>Chelsea</TD><TD>West Brom</TD><TD style="TEXT-ALIGN: right">6</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>Chelsea</TD><TD>West Brom</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: right">14/08/2010</TD><TD>Wigan</TD><TD>Blackpool</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">4</TD><TD>A</TD><TD>Blackpool</TD><TD>Wigan</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: right">14/08/2010</TD><TD>Wolves</TD><TD>Stoke</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">1</TD><TD>H</TD><TD>Wolves</TD><TD>Stoke</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: right">16/08/2010</TD><TD>Man United</TD><TD>Newcastle</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>Man United</TD><TD>Newcastle</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: right">21/08/2010</TD><TD>Arsenal</TD><TD>Blackpool</TD><TD style="TEXT-ALIGN: right">6</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>Arsenal</TD><TD>Blackpool</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: right">21/08/2010</TD><TD>Birmingham</TD><TD>Blackburn</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">1</TD><TD>H</TD><TD>Birmingham</TD><TD>Blackburn</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: right">21/08/2010</TD><TD>Stoke</TD><TD>Tottenham</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">2</TD><TD>A</TD><TD>Tottenham</TD><TD>Stoke</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right">21/08/2010</TD><TD>West Brom</TD><TD>Sunderland</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>West Brom</TD><TD>Sunderland</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: right">21/08/2010</TD><TD>West Ham</TD><TD>Bolton</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">3</TD><TD>A</TD><TD>Bolton</TD><TD>West Ham</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: right">21/08/2010</TD><TD>Wigan</TD><TD>Chelsea</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">6</TD><TD>A</TD><TD>Chelsea</TD><TD>Wigan</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: right">22/08/2010</TD><TD>Newcastle</TD><TD>Aston Villa</TD><TD style="TEXT-ALIGN: right">6</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>Newcastle</TD><TD>Aston Villa</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: right">23/08/2010</TD><TD>Man City</TD><TD>Liverpool</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>Man City</TD><TD>Liverpool</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: right">28/08/2010</TD><TD>Blackburn</TD><TD>Arsenal</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">2</TD><TD>A</TD><TD>Arsenal</TD><TD>Blackburn</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: right">28/08/2010</TD><TD>Chelsea</TD><TD>Stoke</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>Chelsea</TD><TD>Stoke</TD><TD>X</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="TEXT-ALIGN: right">28/08/2010</TD><TD>Man United</TD><TD>West Ham</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>Man United</TD><TD>West Ham</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: right">28/08/2010</TD><TD>Tottenham</TD><TD>Wigan</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1</TD><TD>A</TD><TD>Wigan</TD><TD>Tottenham</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="TEXT-ALIGN: right">29/08/2010</TD><TD>Aston Villa</TD><TD>Everton</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>Aston Villa</TD><TD>Everton</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="TEXT-ALIGN: right">29/08/2010</TD><TD>Liverpool</TD><TD>West Brom</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>Liverpool</TD><TD>West Brom</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="TEXT-ALIGN: right">29/08/2010</TD><TD>Sunderland</TD><TD>Man City</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>Sunderland</TD><TD>Man City</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="TEXT-ALIGN: right">11/09/2010</TD><TD>Arsenal</TD><TD>Bolton</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="TEXT-ALIGN: right">1</TD><TD>H</TD><TD>Arsenal</TD><TD>Bolton</TD><TD>X</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="TEXT-ALIGN: right">11/09/2010</TD><TD>Fulham</TD><TD>Wolves</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">1</TD><TD>H</TD><TD>Fulham</TD><TD>Wolves</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="TEXT-ALIGN: right">11/09/2010</TD><TD>Newcastle</TD><TD>Blackpool</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">2</TD><TD>A</TD><TD>Blackpool</TD><TD>Newcastle</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="TEXT-ALIGN: right">11/09/2010</TD><TD>West Ham</TD><TD>Chelsea</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">3</TD><TD>A</TD><TD>Chelsea</TD><TD>West Ham</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD style="TEXT-ALIGN: right">13/09/2010</TD><TD>Stoke</TD><TD>Aston Villa</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">1</TD><TD>H</TD><TD>Stoke</TD><TD>Aston Villa</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</TD><TD style="TEXT-ALIGN: right">18/09/2010</TD><TD>Everton</TD><TD>Newcastle</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1</TD><TD>A</TD><TD>Newcastle</TD><TD>Everton</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</TD><TD style="TEXT-ALIGN: right">18/09/2010</TD><TD>Tottenham</TD><TD>Wolves</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">1</TD><TD>H</TD><TD>Tottenham</TD><TD>Wolves</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">30</TD><TD style="TEXT-ALIGN: right">18/09/2010</TD><TD>West Brom</TD><TD>Birmingham</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">1</TD><TD>H</TD><TD>West Brom</TD><TD>Birmingham</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</TD><TD style="TEXT-ALIGN: right">19/09/2010</TD><TD>Chelsea</TD><TD>Blackpool</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>Chelsea</TD><TD>Blackpool</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">32</TD><TD style="TEXT-ALIGN: right">19/09/2010</TD><TD>Man United</TD><TD>Liverpool</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">2</TD><TD>H</TD><TD>Man United</TD><TD>Liverpool</TD><TD>X</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">33</TD><TD style="TEXT-ALIGN: right">19/09/2010</TD><TD>Wigan</TD><TD>Man City</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">2</TD><TD>A</TD><TD>Man City</TD><TD>Wigan</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">34</TD><TD style="TEXT-ALIGN: right">25/09/2010</TD><TD>Arsenal</TD><TD>West Brom</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">3</TD><TD>A</TD><TD>West Brom</TD><TD>Arsenal</TD><TD>X</TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>H2</TD><TD>=IF(G2="H",C2,IF(G2="A",D2,""))</TD></TR><TR><TD>I2</TD><TD>=IF(G2="A",C2,IF(G2="H",D2,""))</TD></TR><TR><TD>J2</TD><TD>=IF(MOD(COUNTIF(INDEX(H$2:H$246,IFERROR(MATCH(H2,I$2:I2,0),1)):H2,H2),3),"","X")</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

methody · May 2, 2011

Yes Jason
That's absolutely right and you are right about me using 2003. The formula does not work for me. Is that an issue with iferror.

Does the formula solve the issue of the second streak so if Liverpool won six consecutive games there would be an x after their 3rd win and another after their 6th?

thank you

jasonb75 · May 2, 2011

Unfortunately IFERROR only works with excel 2007 or newer.

How does this look, filtered on Manchester united games only, 3 win streak.

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 82px"><COL style="WIDTH: 82px"><COL style="WIDTH: 39px"><COL style="WIDTH: 39px"><COL style="WIDTH: 29px"><COL style="WIDTH: 79px"><COL style="WIDTH: 82px"><COL style="WIDTH: 89px"><COL style="WIDTH: 56px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD>HomeTeam</TD><TD>AwayTeam</TD><TD>FTHG</TD><TD>FTAG</TD><TD>FTR</TD><TD>Winner</TD><TD>Loser</TD><TD>Loss counter</TD><TD>3 Streak</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD>Man United</TD><TD>Newcastle</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>Man United</TD><TD>Newcastle</TD><TD>Newcastle1</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD>Man United</TD><TD>West Ham</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>Man United</TD><TD>West Ham</TD><TD>West Ham3</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD>Man United</TD><TD>Liverpool</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">2</TD><TD>H</TD><TD>Man United</TD><TD>Liverpool</TD><TD>Liverpool2</TD><TD>X</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD>Stoke</TD><TD>Man United</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">2</TD><TD>A</TD><TD>Man United</TD><TD>Stoke</TD><TD>Stoke5</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD>Man United</TD><TD>Tottenham</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>Man United</TD><TD>Tottenham</TD><TD>Tottenham3</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD>Man United</TD><TD>Wolves</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">1</TD><TD>H</TD><TD>Man United</TD><TD>Wolves</TD><TD>Wolves6</TD><TD>X</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD>Man United</TD><TD>Wigan</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>Man United</TD><TD>Wigan</TD><TD>Wigan6</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD>Man United</TD><TD>Blackburn</TD><TD style="TEXT-ALIGN: right">7</TD><TD style="TEXT-ALIGN: right">1</TD><TD>H</TD><TD>Man United</TD><TD>Blackburn</TD><TD>Blackburn7</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD>Man United</TD><TD>Arsenal</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>Man United</TD><TD>Arsenal</TD><TD>Arsenal5</TD><TD>X</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD>Man United</TD><TD>Sunderland</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>Man United</TD><TD>Sunderland</TD><TD>Sunderland4</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD>West Brom</TD><TD>Man United</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">2</TD><TD>A</TD><TD>Man United</TD><TD>West Brom</TD><TD>West Brom10</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD>Man United</TD><TD>Stoke</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">1</TD><TD>H</TD><TD>Man United</TD><TD>Stoke</TD><TD>Stoke10</TD><TD>X</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD>Man United</TD><TD>Birmingham</TD><TD style="TEXT-ALIGN: right">5</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>Man United</TD><TD>Birmingham</TD><TD>Birmingham7</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD>Blackpool</TD><TD>Man United</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">3</TD><TD>A</TD><TD>Man United</TD><TD>Blackpool</TD><TD>Blackpool11</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD>Man United</TD><TD>Aston Villa</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">1</TD><TD>H</TD><TD>Man United</TD><TD>Aston Villa</TD><TD>Aston Villa11</TD><TD>X</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD>Wolves</TD><TD>Man United</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">1</TD><TD>H</TD><TD>Wolves</TD><TD>Man United</TD><TD>Man United1</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD>Man United</TD><TD>Man City</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">1</TD><TD>H</TD><TD>Man United</TD><TD>Man City</TD><TD>Man City6</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD>Wigan</TD><TD>Man United</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">4</TD><TD>A</TD><TD>Man United</TD><TD>Wigan</TD><TD>Wigan11</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD>Chelsea</TD><TD>Man United</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">1</TD><TD>H</TD><TD>Chelsea</TD><TD>Man United</TD><TD>Man United2</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD>Liverpool</TD><TD>Man United</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">1</TD><TD>H</TD><TD>Liverpool</TD><TD>Man United</TD><TD>Man United3</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD>Man United</TD><TD>Bolton</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>Man United</TD><TD>Bolton</TD><TD>Bolton10</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD>West Ham</TD><TD>Man United</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">4</TD><TD>A</TD><TD>Man United</TD><TD>West Ham</TD><TD>West Ham13</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD>Man United</TD><TD>Fulham</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>Man United</TD><TD>Fulham</TD><TD>Fulham10</TD><TD>X</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD>Man United</TD><TD>Everton</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>Man United</TD><TD>Everton</TD><TD>Everton9</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD>Arsenal</TD><TD>Man United</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD>H</TD><TD>Arsenal</TD><TD>Man United</TD><TD>Man United4</TD><TD> </TD></TR></TBODY></TABLE>

methody · May 2, 2011

that is absolutely brilliant Jason. Thank you - perfect.
I have 2007 as well.
Is there any workaround for 2003? It would be handy.

but thanks again

jasonb75 · May 2, 2011

That was done with a 2003 workaround, but it's a bit lumpy.

How is your sheet laid out, is it anything like the left side of mine?

3 wins in a row

methody

Well-known Member

methody

Well-known Member

Excel Facts

Aladin Akyurek

MrExcel MVP

methody

Well-known Member

Aladin Akyurek

MrExcel MVP

methody

Well-known Member

jasonb75

Well-known Member

methody

Well-known Member

jasonb75

Well-known Member

methody

Well-known Member

jasonb75

Well-known Member

Similar threads

Forum statistics

Share this page

3 wins in a row

Well-known Member

Well-known Member

Excel Facts

MrExcel MVP

Well-known Member

MrExcel MVP

Well-known Member

Well-known Member

Well-known Member

Well-known Member

Well-known Member

Well-known Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock