How to Search for and return the last 12 matches of a value in either of two columns of a table in one worksheet and return those rows in a second wor

W

widgewilliams

New Member
Joined
Apr 11, 2017
Messages
16
Marcelo Branco said:
@widgewilliams

This thread is old and getting very big - difficult to locate the formula you are referring to and the corresponding data.

I suggest you create a new thread by showing us a small sample of your data along with expected results.

To post a sample of your data see section B in
https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html

Then, if you wish, you can put a link here to the new thread.

M.
Click to expand...

As requested I've started a new post for this question.

In one worksheet "Historical Data" I have a table A1:BV1825. The data in that table is 5 years worth or English Premier League Results and is constantly being added to. Columns B through J are the ones of interest for this question.


<tbody>
[TD="class: xl65"][/TD]
[TD="class: xl65, width: 64"]B[/TD]
[TD="class: xl65, width: 64"]C[/TD]
[TD="class: xl65, width: 64"]D[/TD]
[TD="class: xl65, width: 64"]E[/TD]
[TD="class: xl65, width: 64"]F[/TD]
[TD="class: xl65, width: 64"]G[/TD]
[TD="class: xl65, width: 64"]H[/TD]
[TD="class: xl65, width: 64"]I[/TD]
[TD="class: xl65, width: 64"]J[/TD]

[TD="class: xl65"]2[/TD]
[TD="class: xl65"]Date[/TD]
[TD="class: xl65"]HomeTeam[/TD]
[TD="class: xl65"]AwayTeam[/TD]
[TD="class: xl65"]FTHG[/TD]
[TD="class: xl65"]FTAG[/TD]
[TD="class: xl65"]FTR[/TD]
[TD="class: xl65"]HTHG[/TD]
[TD="class: xl65"]HTAG[/TD]
[TD="class: xl65"]HTR[/TD]

[TD="class: xl65"]3[/TD]
[TD="class: xl65"]18/08/12[/TD]
[TD="class: xl65"]Arsenal[/TD]
[TD="class: xl65"]Sunderland[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]D[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]D[/TD]

[TD="class: xl65"]4[/TD]
[TD="class: xl65"]18/08/12[/TD]
[TD="class: xl65"]Fulham[/TD]
[TD="class: xl65"]Norwich[/TD]
[TD="class: xl65"]5[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]

[TD="class: xl65"]5[/TD]
[TD="class: xl65"]18/08/12[/TD]
[TD="class: xl65"]Newcastle[/TD]
[TD="class: xl65"]Tottenham[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]H[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]D[/TD]

[TD="class: xl65"]6[/TD]
[TD="class: xl65"]18/08/12[/TD]
[TD="class: xl65"]QPR[/TD]
[TD="class: xl65"]Swansea[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]5[/TD]
[TD="class: xl65"]A[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]A[/TD]

[TD="class: xl65"]7[/TD]
[TD="class: xl65"]18/08/12[/TD]
[TD="class: xl65"]Reading[/TD]
[TD="class: xl65"]Stoke[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]D[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]A[/TD]

[TD="class: xl65"]8[/TD]
[TD="class: xl65"]18/08/12[/TD]
[TD="class: xl65"]West Brom[/TD]
[TD="class: xl65"]Liverpool[/TD]
[TD="class: xl65"]3[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]

[TD="class: xl65"]9[/TD]
[TD="class: xl65"]18/08/12[/TD]
[TD="class: xl65"]West Ham[/TD]
[TD="class: xl65"]Aston Villa[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]

[TD="class: xl65"]10[/TD]
[TD="class: xl65"]19/08/12[/TD]
[TD="class: xl65"]Man City[/TD]
[TD="class: xl65"]Southampton[/TD]
[TD="class: xl65"]3[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]H[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]

</tbody>


Each week new rows are added to the bottom of the table as the football seasons progress. Currently the last row is 1825.


<tbody>
[TD="class: xl65"]1825[/TD]
[TD="class: xl66, width: 64"]5/4/2017[/TD]
[TD="class: xl65, width: 64"]Swansea[/TD]
[TD="class: xl65, width: 64"]Tottenham[/TD]
[TD="class: xl65, width: 64"]1[/TD]
[TD="class: xl65, width: 64"]3[/TD]
[TD="class: xl65, width: 64"]A[/TD]
[TD="class: xl65, width: 64"]1[/TD]
[TD="class: xl65, width: 64"]0[/TD]
[TD="class: xl65, width: 64"]H[/TD]

</tbody>

In a seperate worksheet "Output" I have a Drop Down List containing the names of each team in the English Premiership.

By selecting any particular team in the drop down list I am looking to pull a range of statistics for that team and display them in the Output worksheet.

One of those sets of statistics is the Current Form of the team over their last 12 games - both home and away.

What I (think) I need to be able to do is to look up columns C and D in the "Historical Data" worksheet to find matches to the drop down box Output!$B$2 and return the last 12 rows where there is a match to get both the Home and Away Form for the particular team I'm interested in and create a new table in the Output worksheet for those last 12 games with the following headings


<tbody>
[TD="class: xl65, colspan: 2"]Date[/TD]
[TD="class: xl65, width: 122, colspan: 3"]Home Team[/TD]
[TD="class: xl65, width: 120, colspan: 3"]Away Team[/TD]
[TD="class: xl65, width: 120, colspan: 3"]Half Time Score[/TD]
[TD="class: xl65, width: 120, colspan: 3"]Full Time Score[/TD]

</tbody>


I know that the following formula would find and display what I am after...

{=IFERROR(INDEX('Historical Data'!B$2:B$9999,SMALL(IF((('Historical Data'!$C$2:$C$9999=Output!$B$2)+('Historical Data'!$D$2:$D$9999=Output!$B$2)),ROW('Historical Data'!B$2:B$9999)-ROW('Historical Data'!B$2)+1),ROWS('Historical Data'!B$2:'Historical Data'!B2))),"")}

However, it will find and match working from row 1 downwards and so extract the oldest data first as shown below (with West Brom being the search value in this instance)


<colgroup><col style="mso-width-source:userset;mso-width-alt:2340;width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:1755;width:36pt" width="48"> <col style="mso-width-source:userset;mso-width-alt:1536;width:32pt" width="42"> <col style="mso-width-source:userset;mso-width-alt:1462; width:30pt" span="11" width="40"> </colgroup><tbody>
[TD="class: xl65, width: 112, colspan: 2"]Date[/TD]
[TD="class: xl65, width: 122, colspan: 3"]Home Team[/TD]
[TD="class: xl65, width: 120, colspan: 3"]Away Team[/TD]
[TD="class: xl65, width: 120, colspan: 3"]Half Time[/TD]
[TD="class: xl65, width: 120, colspan: 3"]Full Time[/TD]

[TD="class: xl66, colspan: 2"]18/08/12[/TD]
[TD="class: xl65, colspan: 3"]West Brom[/TD]
[TD="class: xl65, colspan: 3"]Liverpool[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]
[TD="class: xl65"]3[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]

[TD="class: xl66, colspan: 2"]25/08/12[/TD]
[TD="class: xl65, colspan: 3"]Tottenham[/TD]
[TD="class: xl65, colspan: 3"]West Brom[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]D[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]D[/TD]

[TD="class: xl66, colspan: 2"]1/9/2012[/TD]
[TD="class: xl65, colspan: 3"]West Brom[/TD]
[TD="class: xl65, colspan: 3"]Everton[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]D[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]

[TD="class: xl66, colspan: 2"]15/09/12[/TD]
[TD="class: xl65, colspan: 3"]Fulham[/TD]
[TD="class: xl65, colspan: 3"]West Brom[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]
[TD="class: xl65"]3[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]

[TD="class: xl66, colspan: 2"]22/09/12[/TD]
[TD="class: xl65, colspan: 3"]West Brom[/TD]
[TD="class: xl65, colspan: 3"]Reading[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]D[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]

[TD="class: xl66, colspan: 2"]30/09/12[/TD]
[TD="class: xl65, colspan: 3"]Aston Villa[/TD]
[TD="class: xl65, colspan: 3"]West Brom[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]D[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]D[/TD]

[TD="class: xl66, colspan: 2"]6/10/2012[/TD]
[TD="class: xl65, colspan: 3"]West Brom[/TD]
[TD="class: xl65, colspan: 3"]QPR[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]H[/TD]
[TD="class: xl65"]3[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]H[/TD]

[TD="class: xl66, colspan: 2"]20/10/12[/TD]
[TD="class: xl65, colspan: 3"]West Brom[/TD]
[TD="class: xl65, colspan: 3"]Man City[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]D[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]A[/TD]

[TD="class: xl66, colspan: 2"]28/10/12[/TD]
[TD="class: xl65, colspan: 3"]Newcastle[/TD]
[TD="class: xl65, colspan: 3"]West Brom[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]H[/TD]

[TD="class: xl66, colspan: 2"]5/11/2012[/TD]
[TD="class: xl65, colspan: 3"]West Brom[/TD]
[TD="class: xl65, colspan: 3"]Southampton[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]

[TD="class: xl66, colspan: 2"]10/11/2012[/TD]
[TD="class: xl65, colspan: 3"]Wigan[/TD]
[TD="class: xl65, colspan: 3"]West Brom[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]A[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]A[/TD]

[TD="class: xl66, colspan: 2"]17/11/12[/TD]
[TD="class: xl65, colspan: 3"]West Brom[/TD]
[TD="class: xl65, colspan: 3"]Chelsea[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]D[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]H[/TD]

</tbody>


What I am needing to do is start from the most recent matches which are to be found at the bottom of the historic data table and work backwards.

Can it be done, and how could I do it?

Thanks
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Sort by date Sort by votes
Eric W said:
Try putting LARGE instead of SMALL in that formula.
Click to expand...

Well, that was remarkably simple....


<colgroup><col style="mso-width-source:userset;mso-width-alt:2340;width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:1755;width:36pt" width="48"> <col style="mso-width-source:userset;mso-width-alt:1536;width:32pt" width="42"> <col style="mso-width-source:userset;mso-width-alt:1462; width:30pt" span="11" width="40"> </colgroup><tbody>
[TD="class: xl65, width: 112, colspan: 2"]Date[/TD]
[TD="class: xl65, width: 122, colspan: 3"]Home Team[/TD]
[TD="class: xl65, width: 120, colspan: 3"]Away Team[/TD]
[TD="class: xl65, width: 120, colspan: 3"]Half Time[/TD]
[TD="class: xl65, width: 120, colspan: 3"]Full Time[/TD]

[TD="class: xl66, colspan: 2"]4/4/2017[/TD]
[TD="class: xl66, colspan: 3"]Watford[/TD]
[TD="class: xl66, colspan: 3"]West Brom[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl66"]H[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]

[TD="class: xl66, colspan: 2"]4/1/2017[/TD]
[TD="class: xl66, colspan: 3"]Man United[/TD]
[TD="class: xl66, colspan: 3"]West Brom[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl66"]D[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]D[/TD]

[TD="class: xl66, colspan: 2"]3/18/2017[/TD]
[TD="class: xl66, colspan: 3"]West Brom[/TD]
[TD="class: xl66, colspan: 3"]Arsenal[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl66"]D[/TD]
[TD="class: xl65"]3[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]H[/TD]

[TD="class: xl66, colspan: 2"]3/11/2017[/TD]
[TD="class: xl66, colspan: 3"]Everton[/TD]
[TD="class: xl66, colspan: 3"]West Brom[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl66"]H[/TD]
[TD="class: xl65"]3[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]

[TD="class: xl66, colspan: 2"]3/4/2017[/TD]
[TD="class: xl66, colspan: 3"]West Brom[/TD]
[TD="class: xl66, colspan: 3"]Crystal Palace[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl66"]D[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]A[/TD]

[TD="class: xl66, colspan: 2"]2/25/2017[/TD]
[TD="class: xl66, colspan: 3"]West Brom[/TD]
[TD="class: xl66, colspan: 3"]Bournemouth[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl66"]H[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]H[/TD]

[TD="class: xl66, colspan: 2"]2/11/2017[/TD]
[TD="class: xl66, colspan: 3"]West Ham[/TD]
[TD="class: xl66, colspan: 3"]West Brom[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl66"]A[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]D[/TD]

[TD="class: xl66, colspan: 2"]2/4/2017[/TD]
[TD="class: xl66, colspan: 3"]West Brom[/TD]
[TD="class: xl66, colspan: 3"]Stoke[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl66"]H[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]

[TD="class: xl66, colspan: 2"]1/31/2017[/TD]
[TD="class: xl66, colspan: 3"]Middlesbrough[/TD]
[TD="class: xl66, colspan: 3"]West Brom[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl66"]D[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]D[/TD]

[TD="class: xl66, colspan: 2"]1/21/2017[/TD]
[TD="class: xl66, colspan: 3"]West Brom[/TD]
[TD="class: xl66, colspan: 3"]Sunderland[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl66"]H[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]

[TD="class: xl66, colspan: 2"]1/14/2017[/TD]
[TD="class: xl66, colspan: 3"]Tottenham[/TD]
[TD="class: xl66, colspan: 3"]West Brom[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl66"]H[/TD]
[TD="class: xl65"]4[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]

[TD="class: xl66, colspan: 2"]1/2/2017[/TD]
[TD="class: xl66, colspan: 3"]West Brom[/TD]
[TD="class: xl66, colspan: 3"]Hull[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl66"]A[/TD]
[TD="class: xl65"]3[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]H[/TD]

</tbody>

A bit of cut and pasting to rearrange the order...


<colgroup><col style="mso-width-source:userset;mso-width-alt:2340;width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:1755;width:36pt" width="48"> <col style="mso-width-source:userset;mso-width-alt:1536;width:32pt" width="42"> <col style="mso-width-source:userset;mso-width-alt:1462; width:30pt" span="11" width="40"> </colgroup><tbody>
[TD="class: xl65, width: 112, colspan: 2"]Date[/TD]
[TD="class: xl65, width: 122, colspan: 3"]Home Team[/TD]
[TD="class: xl65, width: 120, colspan: 3"]Away Team[/TD]
[TD="class: xl65, width: 120, colspan: 3"]Half Time[/TD]
[TD="class: xl65, width: 120, colspan: 3"]Full Time[/TD]

[TD="class: xl66, colspan: 2"]1/2/2017[/TD]
[TD="class: xl66, colspan: 3"]West Brom[/TD]
[TD="class: xl66, colspan: 3"]Hull[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl66"]A[/TD]
[TD="class: xl65"]3[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]H[/TD]

[TD="class: xl66, colspan: 2"]1/14/2017[/TD]
[TD="class: xl66, colspan: 3"]Tottenham[/TD]
[TD="class: xl66, colspan: 3"]West Brom[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl66"]H[/TD]
[TD="class: xl65"]4[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]

[TD="class: xl66, colspan: 2"]1/21/2017[/TD]
[TD="class: xl66, colspan: 3"]West Brom[/TD]
[TD="class: xl66, colspan: 3"]Sunderland[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl66"]H[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]

[TD="class: xl66, colspan: 2"]1/31/2017[/TD]
[TD="class: xl66, colspan: 3"]Middlesbrough[/TD]
[TD="class: xl66, colspan: 3"]West Brom[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl66"]D[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]D[/TD]

[TD="class: xl66, colspan: 2"]2/4/2017[/TD]
[TD="class: xl66, colspan: 3"]West Brom[/TD]
[TD="class: xl66, colspan: 3"]Stoke[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl66"]H[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]

[TD="class: xl66, colspan: 2"]2/11/2017[/TD]
[TD="class: xl66, colspan: 3"]West Ham[/TD]
[TD="class: xl66, colspan: 3"]West Brom[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl66"]A[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]D[/TD]

[TD="class: xl66, colspan: 2"]2/25/2017[/TD]
[TD="class: xl66, colspan: 3"]West Brom[/TD]
[TD="class: xl66, colspan: 3"]Bournemouth[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl66"]H[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]H[/TD]

[TD="class: xl66, colspan: 2"]3/4/2017[/TD]
[TD="class: xl66, colspan: 3"]West Brom[/TD]
[TD="class: xl66, colspan: 3"]Crystal Palace[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl66"]D[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]A[/TD]

[TD="class: xl66, colspan: 2"]3/11/2017[/TD]
[TD="class: xl66, colspan: 3"]Everton[/TD]
[TD="class: xl66, colspan: 3"]West Brom[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl66"]H[/TD]
[TD="class: xl65"]3[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]

[TD="class: xl66, colspan: 2"]3/18/2017[/TD]
[TD="class: xl66, colspan: 3"]West Brom[/TD]
[TD="class: xl66, colspan: 3"]Arsenal[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl66"]D[/TD]
[TD="class: xl65"]3[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]H[/TD]

[TD="class: xl66, colspan: 2"]4/1/2017[/TD]
[TD="class: xl66, colspan: 3"]Man United[/TD]
[TD="class: xl66, colspan: 3"]West Brom[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl66"]D[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]D[/TD]

[TD="class: xl66, colspan: 2"]4/4/2017[/TD]
[TD="class: xl66, colspan: 3"]Watford[/TD]
[TD="class: xl66, colspan: 3"]West Brom[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl66"]H[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]H[/TD]

</tbody>

And it is exactly what I was wanting to achieve. Clearly i need to understand what the Large and Small functions actually do.

Thank you so much Eric.
 
Upvote 0
Don't be confused my my setup here - I used your 'output' data as my source data. I extracted the most recent game into Row 18, the second most recent into Row 19 and onwards. I used an expanding range as part of the function AGGREGATE, whose function_num is 14 for LARGE. Copy B18 rightways. Then Copy Row 18 downwards for as many games as you want to extract (up to the number of games the team played in the master list (12 in my case).

ABCDEFGHI
LiverpoolHH
TottenhamDD
EvertonDH
FulhamHH
ReadingDH
Aston VillaWest BromDD
QPRHH
Man CityDA
NewcastleHH
SouthamptonHH
WiganWest BromAA
ChelseaDH
et cetera

<tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: #FFE699"]Date[/TD]
[TD="bgcolor: #FFE699"]Home Team[/TD]
[TD="bgcolor: #FFE699"]Away Team[/TD]
[TD="bgcolor: #FFF2CC"]Half Time[/TD]
[TD="bgcolor: #FFF2CC, align: right"][/TD]
[TD="bgcolor: #FFF2CC, align: right"][/TD]
[TD="bgcolor: #FFE699"]Full Time[/TD]
[TD="bgcolor: #FFE699, align: right"][/TD]
[TD="bgcolor: #FFE699, align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]8/18/2012[/TD]
[TD="bgcolor: #FFFF00"]West Brom[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]8/25/2012[/TD]

[TD="bgcolor: #FFFF00"]West Brom[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]9/1/2012[/TD]
[TD="bgcolor: #FFFF00"]West Brom[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]9/15/2012[/TD]

[TD="bgcolor: #FFFF00"]West Brom[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]9/22/2012[/TD]
[TD="bgcolor: #FFFF00"]West Brom[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]9/30/2012[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]10/6/2012[/TD]
[TD="bgcolor: #FFFF00"]West Brom[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]10/20/2012[/TD]
[TD="bgcolor: #FFFF00"]West Brom[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]10/28/2012[/TD]

[TD="bgcolor: #FFFF00"]West Brom[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]11/5/2012[/TD]
[TD="bgcolor: #FFFF00"]West Brom[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]11/10/2012[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]11/17/2012[/TD]
[TD="bgcolor: #FFFF00"]West Brom[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]
[TD="bgcolor: #FFF2CC"]Lookup:[/TD]
[TD="bgcolor: #FFFF00"]West Brom[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]
[TD="bgcolor: #FCE4D6"]Date[/TD]
[TD="bgcolor: #FCE4D6"]Home Team[/TD]
[TD="bgcolor: #FCE4D6"]Away Team[/TD]
[TD="bgcolor: #FCE4D6"]Half Time Score[/TD]
[TD="bgcolor: #FCE4D6, align: right"][/TD]
[TD="bgcolor: #FCE4D6, align: right"][/TD]
[TD="bgcolor: #FCE4D6"]Full Time Score[/TD]
[TD="bgcolor: #FCE4D6, align: right"][/TD]
[TD="bgcolor: #FCE4D6, align: right"][/TD]

[TD="align: center"]18[/TD]
[TD="bgcolor: #E2EFDA, align: right"]11/17/2012[/TD]
[TD="bgcolor: #E2EFDA"]West Brom[/TD]
[TD="bgcolor: #E2EFDA"]Chelsea[/TD]
[TD="bgcolor: #E2EFDA, align: right"]1[/TD]
[TD="bgcolor: #E2EFDA, align: right"]1[/TD]
[TD="bgcolor: #E2EFDA"]D[/TD]
[TD="bgcolor: #E2EFDA, align: right"]2[/TD]
[TD="bgcolor: #E2EFDA, align: right"]1[/TD]
[TD="bgcolor: #E2EFDA"]H[/TD]

[TD="align: center"]19[/TD]
[TD="bgcolor: #E2EFDA, align: right"]11/10/2012[/TD]
[TD="bgcolor: #E2EFDA"]Wigan[/TD]
[TD="bgcolor: #E2EFDA"]West Brom[/TD]
[TD="bgcolor: #E2EFDA, align: right"]1[/TD]
[TD="bgcolor: #E2EFDA, align: right"]2[/TD]
[TD="bgcolor: #E2EFDA"]A[/TD]
[TD="bgcolor: #E2EFDA, align: right"]1[/TD]
[TD="bgcolor: #E2EFDA, align: right"]2[/TD]
[TD="bgcolor: #E2EFDA"]A[/TD]

[TD="align: center"]20[/TD]
[TD="bgcolor: #E2EFDA, align: right"]11/5/2012[/TD]
[TD="bgcolor: #E2EFDA"]West Brom[/TD]
[TD="bgcolor: #E2EFDA"]Southampton[/TD]
[TD="bgcolor: #E2EFDA, align: right"]1[/TD]
[TD="bgcolor: #E2EFDA, align: right"]0[/TD]
[TD="bgcolor: #E2EFDA"]H[/TD]
[TD="bgcolor: #E2EFDA, align: right"]2[/TD]
[TD="bgcolor: #E2EFDA, align: right"]0[/TD]
[TD="bgcolor: #E2EFDA"]H[/TD]

[TD="align: center"]21[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>
Sheet58​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TH="width: 10"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="width: 10, bgcolor: #DAE7F5"]A18[/TH]
[TD="align: left"]=AGGREGATE(14,6,($B$15=$B$2:$C$13)*$A$2:$A$13,ROWS($A$18:A18))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #DAE7F5"]B18[/TH]
[TD="align: left"]=INDEX(B$2:B$13,MATCH($A18,$A$2:$A$13))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
 
Last edited:
Upvote 0
To avoid the cutting and pasting, you could do this:

{=IFERROR(INDEX('Historical Data'!B$2:B$9999,LARGE(IF((('Historical Data'!$C$2:$C$9999=Output!$B$2)+('Historical Data'!$D$2:$D$9999=Output!$B$2)),ROW('Historical Data'!B$2:B$9999)-ROW('Historical Data'!B$2)+1),13-ROWS('Historical Data'!B$2:'Historical Data'!B2))),"")}

Glad we could help.
 
Upvote 0
Eric W said:
To avoid the cutting and pasting, you could do this:

{=IFERROR(INDEX('Historical Data'!B$2:B$9999,LARGE(IF((('Historical Data'!$C$2:$C$9999=Output!$B$2)+('Historical Data'!$D$2:$D$9999=Output!$B$2)),ROW('Historical Data'!B$2:B$9999)-ROW('Historical Data'!B$2)+1),13-ROWS('Historical Data'!B$2:'Historical Data'!B2))),"")}

Glad we could help.
Click to expand...

That certainly does the trick Eric. Thanks again.

DRSteele said:
Eric certainly seems to have provided a solution to my question and fixed the need for cutting and pasting, but having taken the time to respond to me DRSteele it would only be right for me to take a look at your proposed solution also which, i suspect, would help me in some of the other things I am wanting to do.

I've have encountered a problem though in that I get the following results.

DH
AA
DH
DA
HH
AD
HH
HH
HH
DH
DA

<tbody>
[TD="class: xl66, colspan: 2, align: right"]4/4/2017[/TD]
[TD="class: xl65, width: 120, colspan: 3"]Watford[/TD]
[TD="width: 120, colspan: 3"]West Brom[/TD]
[TD="width: 40, align: right"]1[/TD]
[TD="width: 40, align: right"]0[/TD]
[TD="width: 40"]H[/TD]
[TD="width: 40, align: right"]2[/TD]
[TD="width: 40, align: right"]0[/TD]
[TD="width: 40"]H[/TD]

[TD="class: xl66, colspan: 2, align: right"]4/1/2017[/TD]
[TD="class: xl65, colspan: 3"]Watford[/TD]
[TD="colspan: 3"]Sunderland[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl66, colspan: 2, align: right"]3/18/2017[/TD]
[TD="class: xl65, colspan: 3"]West Ham[/TD]
[TD="colspan: 3"]Leicester[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]

[TD="class: xl66, colspan: 2, align: right"]3/11/2017[/TD]
[TD="class: xl65, colspan: 3"]Hull[/TD]
[TD="colspan: 3"]Swansea[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]

[TD="class: xl66, colspan: 2, align: right"]3/4/2017[/TD]
[TD="class: xl65, colspan: 3"]West Brom[/TD]
[TD="colspan: 3"]Crystal Palace[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]

[TD="class: xl66, colspan: 2, align: right"]2/25/2017[/TD]
[TD="class: xl65, colspan: 3"]West Brom[/TD]
[TD="colspan: 3"]Bournemouth[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]

[TD="class: xl66, colspan: 2, align: right"]2/11/2017[/TD]
[TD="class: xl65, colspan: 3"]West Ham[/TD]
[TD="colspan: 3"]West Brom[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]

[TD="class: xl66, colspan: 2, align: right"]2/4/2017[/TD]
[TD="class: xl65, colspan: 3"]West Brom[/TD]
[TD="colspan: 3"]Stoke[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl66, colspan: 2, align: right"]1/31/2017[/TD]
[TD="class: xl65, colspan: 3"]Swansea[/TD]
[TD="colspan: 3"]Southampton[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]

[TD="class: xl66, colspan: 2, align: right"]1/21/2017[/TD]
[TD="class: xl65, colspan: 3"]West Brom[/TD]
[TD="colspan: 3"]Sunderland[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl66, colspan: 2, align: right"]1/14/2017[/TD]
[TD="class: xl65, colspan: 3"]West Ham[/TD]
[TD="colspan: 3"]Crystal Palace[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl66, colspan: 2, align: right"]1/2/2017[/TD]
[TD="class: xl65, colspan: 3"]West Ham[/TD]
[TD="colspan: 3"]Man United[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]

</tbody>


I suspect that the reason is because my actual source data contains every game played in the EPL, and not just West Brom's.

Would I be right in thinking that A18 pulls the dates of West Broms last 12 games, and B12 then matches to that date? If so then what seems to be happening is that B12 is retrieving the last game in the source data for that particular date, as can be seen below.

EvertonWest BromHH
LiverpoolBurnleyHD
BournemouthSwanseaHH
Crystal PalaceWatfordHD
EvertonHullHH
StokeChelseaAD
SunderlandBurnleyDD
West BromArsenalHD
Man CityLiverpoolDD
MiddlesbroughMan UnitedAA
TottenhamSouthamptonHH
BurnleyTottenhamAD
ChelseaCrystal PalaceAA
HullWest HamHA
LeicesterStokeHH
LiverpoolEvertonHH
Man UnitedWest BromDD
SouthamptonBournemouthDD
ArsenalMan CityDA
SwanseaMiddlesbroughDD
BurnleyStokeHD
LeicesterSunderlandHD
Man UnitedEvertonDA
ArsenalWest HamHD
ChelseaMan CityHH
HullMiddlesbroughHH
LiverpoolBournemouthDD
SouthamptonCrystal PalaceHD
SwanseaTottenhamAH

<tbody>
[TD="class: xl65, align: right"]3/11/2017[/TD]
[TD="width: 64"]Bournemouth[/TD]
[TD="width: 64"]West Ham[/TD]
[TD="width: 64, align: right"]3[/TD]
[TD="width: 64, align: right"]2[/TD]
[TD="width: 64"]H[/TD]
[TD="width: 64, align: right"]1[/TD]
[TD="width: 64, align: right"]1[/TD]
[TD="width: 64"]D[/TD]

[TD="class: xl65, align: right"]3/11/2017[/TD]

[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl67, align: right"] 3/11/2017
 [/TD]
[TD="class: xl66"] Hull [/TD]
[TD="class: xl66"] Swansea [/TD]
[TD="class: xl66, align: right"] 2 [/TD]
[TD="class: xl66, align: right"] 1 [/TD]
[TD="class: xl66"] H [/TD]
[TD="class: xl66, align: right"] 0 [/TD]
[TD="class: xl66, align: right"] 0 [/TD]
[TD="class: xl66"] D [/TD]

[TD="class: xl65, align: right"]3/12/2017[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]

[TD="class: xl65, align: right"]3/18/2017[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl65, align: right"]3/18/2017[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl65, align: right"]3/18/2017[/TD]

[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl65, align: right"]3/18/2017[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]

[TD="class: xl65, align: right"]3/18/2017[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl65, align: right"]3/18/2017[/TD]

[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]

[TD="class: xl67, align: right"] 3/18/2017
 [/TD]
[TD="class: xl66"] West Ham [/TD]
[TD="class: xl66"] Leicester [/TD]
[TD="class: xl66, align: right"] 2 [/TD]
[TD="class: xl66, align: right"] 3 [/TD]
[TD="class: xl66"] A [/TD]
[TD="class: xl66, align: right"] 1 [/TD]
[TD="class: xl66, align: right"] 3 [/TD]
[TD="class: xl66"] A [/TD]

[TD="class: xl65, align: right"]3/19/2017[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl65, align: right"]3/19/2017[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]

[TD="class: xl65, align: right"]3/19/2017[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl65, align: right"]4/1/2017[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl65, align: right"]4/1/2017[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]

[TD="class: xl65, align: right"]4/1/2017[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]

[TD="class: xl65, align: right"]4/1/2017[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl65, align: right"]4/1/2017[/TD]

[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]

[TD="class: xl65, align: right"]4/1/2017[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl65, align: right"]4/1/2017[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl67, align: right"] 4/1/2017
 [/TD]
[TD="class: xl66"] Watford [/TD]
[TD="class: xl66"] Sunderland [/TD]
[TD="class: xl66, align: right"] 1 [/TD]
[TD="class: xl66, align: right"] 0 [/TD]
[TD="class: xl66"] H [/TD]
[TD="class: xl66, align: right"] 0 [/TD]
[TD="class: xl66, align: right"] 0 [/TD]
[TD="class: xl66"] D [/TD]

[TD="class: xl65, align: right"]4/2/2017[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]

[TD="class: xl65, align: right"]4/2/2017[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl65, align: right"]4/4/2017[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl65, align: right"]4/4/2017[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl65, align: right"]4/4/2017[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]

[TD="class: xl67, align: right"] 4/4/2017
 [/TD]
[TD="class: xl66"] Watford [/TD]
[TD="class: xl66"] West Brom [/TD]
[TD="class: xl66, align: right"] 2 [/TD]
[TD="class: xl66, align: right"] 0 [/TD]
[TD="class: xl66"] H [/TD]
[TD="class: xl66, align: right"] 1 [/TD]
[TD="class: xl66, align: right"] 0 [/TD]
[TD="class: xl66"] H [/TD]

[TD="class: xl65, align: right"]5/4/2017[/TD]

[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl65, align: right"]5/4/2017[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]

[TD="class: xl65, align: right"]5/4/2017[/TD]

[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]

[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]

[TD="class: xl65, align: right"]5/4/2017[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]

[TD="class: xl65, align: right"]5/4/2017[/TD]

[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]

[TD="class: xl65, align: right"]5/4/2017[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]

</tbody>
Click to expand...
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
Calculate last 5 soccer team goals using data from another sheet on same workbook.
2
Replies
19
Views
2K
felixstraube
F
B
  • Question Question
Matching Multiple Header Row Cell Values - Copy the data below to next available row.
Replies
2
Views
565
B-radK
B
S
  • Solved
Find Value in Table
2
Replies
17
Views
526
Peter_SSs
Peter_SSs
P
  • Question Question
How to obtain average values on columns filter
Replies
3
Views
210
StephenCrump
S
M
  • Question Question
Pivot table not showing as Numbers
Replies
1
Views
274
shift-del
shift-del

Forum statistics

Threads
1,223,941
Messages
6,175,537
Members
452,652
Latest member
eduedu

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top