Summarising data between a range of dates issue

[PeterG83]

Hi there,

I am trying to pull together some simple analysis on performance in a game. Each week we mix up the teams and I have recorded who won, lost, drew etc and have scored people the same way that football teams are scored (3,1,0)

The analysis looks like below. What i want to do though is be able to put in a range of dates in two cells (eg 3/1/2013 to 14/3/2013) and the data will summarise for performance between those dates.
How would i go about doing this? I thought about numbering the 52 weeks 1 to 52 instead of the dates but im still not sure how to do it!

So you know what i have done:

• the number of number of draws and wins etc i have used countif.
• N= did not play
• w=win
• d=draw
• L=lost

Thanks
Pete
[TABLE="width: 4435"]
<TBODY>[TR]
[TD]Quarter
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]4
[/TD]
[TD]4
[/TD]
[TD]4
[/TD]
[TD]4
[/TD]
[TD]4
[/TD]
[TD]4
[/TD]
[TD]4
[/TD]
[TD]4
[/TD]
[TD]4
[/TD]
[TD]4
[/TD]
[TD]4
[/TD]
[TD]4
[/TD]
[TD]4
[/TD]
[TD="colspan: 6"]Overall Totals
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date
[/TD]
[TD]14-Jun
[/TD]
[TD]21-Jun
[/TD]
[TD]28-Jun
[/TD]
[TD]05-Jul
[/TD]
[TD]12-Jul
[/TD]
[TD]19-Jul
[/TD]
[TD]26-Jul
[/TD]
[TD]02-Aug
[/TD]
[TD]09-Aug
[/TD]
[TD]16-Aug
[/TD]
[TD]23-Aug
[/TD]
[TD]30-Aug
[/TD]
[TD]06-Sep
[/TD]
[TD]13-Sep
[/TD]
[TD]20-Sep
[/TD]
[TD]27-Sep
[/TD]
[TD]04-Oct
[/TD]
[TD]11-Oct
[/TD]
[TD]18-Oct
[/TD]
[TD]25-Oct
[/TD]
[TD]01-Nov
[/TD]
[TD]08-Nov
[/TD]
[TD]15-Nov
[/TD]
[TD]22-Nov
[/TD]
[TD]29-Nov
[/TD]
[TD]06-Dec
[/TD]
[TD]13-Dec
[/TD]
[TD]20-Dec
[/TD]
[TD]27-Dec
[/TD]
[TD]03-Jan
[/TD]
[TD]10-Jan
[/TD]
[TD]17-Jan
[/TD]
[TD]24-Jan
[/TD]
[TD]31-Jan
[/TD]
[TD]07-Feb
[/TD]
[TD]14-Feb
[/TD]
[TD]21-Feb
[/TD]
[TD]28-Feb
[/TD]
[TD]07-Mar
[/TD]
[TD]14-Mar
[/TD]
[TD]21-Mar
[/TD]
[TD]28-Mar
[/TD]
[TD]04-Apr
[/TD]
[TD]11-Apr
[/TD]
[TD]18-Apr
[/TD]
[TD]25-Apr
[/TD]
[TD]02-May
[/TD]
[TD]09-May
[/TD]
[TD]16-May
[/TD]
[TD]23-May
[/TD]
[TD]30-May
[/TD]
[TD]06-Jun
[/TD]
[TD]Total wins
[/TD]
[TD]Total draws
[/TD]
[TD]Total losses
[/TD]
[TD]DNP
[/TD]
[TD]Total games
[/TD]
[TD]Should equal game week
[/TD]
[TD]Win %
[/TD]
[TD]Total points
[/TD]
[TD]Average points per game
[/TD]
[/TR]
[TR]
[TD]Ben
[/TD]
[TD]N
[/TD]
[TD]D
[/TD]
[TD]L
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]L
[/TD]
[TD]L
[/TD]
[TD]W
[/TD]
[TD]L
[/TD]
[TD]L
[/TD]
[TD]L
[/TD]
[TD]N
[/TD]
[TD]W
[/TD]
[TD]L
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]L
[/TD]
[TD]W
[/TD]
[TD]W
[/TD]
[TD]D
[/TD]
[TD]N
[/TD]
[TD]L
[/TD]
[TD]L
[/TD]
[TD]L
[/TD]
[TD]L
[/TD]
[TD]N
[/TD]
[TD]W
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]L
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]L
[/TD]
[TD]L
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5
[/TD]
[TD]2
[/TD]
[TD]15
[/TD]
[TD]14
[/TD]
[TD]22
[/TD]
[TD]36
[/TD]
[TD]22.73%
[/TD]
[TD="align: right"]17
[/TD]
[TD="align: right"]0.77
[/TD]
[/TR]
[TR]
[TD]Chris
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]L
[/TD]
[TD]N
[/TD]
[TD]L
[/TD]
[TD]L
[/TD]
[TD]W
[/TD]
[TD]W
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]L
[/TD]
[TD]W
[/TD]
[TD]N
[/TD]
[TD]D
[/TD]
[TD]L
[/TD]
[TD]N
[/TD]
[TD]L
[/TD]
[TD]L
[/TD]
[TD]L
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]W
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]W
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5
[/TD]
[TD]1
[/TD]
[TD]8
[/TD]
[TD]22
[/TD]
[TD]14
[/TD]
[TD]36
[/TD]
[TD]35.71%
[/TD]
[TD="align: right"]16
[/TD]
[TD="align: right"]1.14
[/TD]
[/TR]
[TR]
[TD]Sagar
[/TD]
[TD]N
[/TD]
[TD]D
[/TD]
[TD]L
[/TD]
[TD]W
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]L
[/TD]
[TD]W
[/TD]
[TD]W
[/TD]
[TD]N
[/TD]
[TD]L
[/TD]
[TD]L
[/TD]
[TD]W
[/TD]
[TD]N
[/TD]
[TD]D
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]L
[/TD]
[TD]D
[/TD]
[TD]W
[/TD]
[TD]L
[/TD]
[TD]W
[/TD]
[TD]W
[/TD]
[TD]L
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]W
[/TD]
[TD]W
[/TD]
[TD]W
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]10
[/TD]
[TD]3
[/TD]
[TD]7
[/TD]
[TD]16
[/TD]
[TD]20
[/TD]
[TD]36
[/TD]
[TD]50.00%
[/TD]
[TD="align: right"]33
[/TD]
[TD="align: right"]1.65
[/TD]
[/TR]
[TR]
[TD]Tom M
[/TD]
[TD]N
[/TD]
[TD]D
[/TD]
[TD]W
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]W
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]W
[/TD]
[TD]W
[/TD]
[TD]N
[/TD]
[TD]W
[/TD]
[TD]N
[/TD]
[TD]L
[/TD]
[TD]D
[/TD]
[TD]W
[/TD]
[TD]L
[/TD]
[TD]N
[/TD]
[TD]W
[/TD]
[TD]D
[/TD]
[TD]L
[/TD]
[TD]L
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]L
[/TD]
[TD]L
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD]N
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]7
[/TD]
[TD]3
[/TD]
[TD]6
[/TD]
[TD]20
[/TD]
[TD]16
[/TD]
[TD]36
[/TD]
[TD]43.75%
[/TD]
[TD="align: right"]24
[/TD]
[TD="align: right"]1.50
[/TD]
[/TR]
</TBODY>[/TABLE]

 

[Akashwani]

Hi,

Can you tell me what the first date is please?
14-Jun = 14/06/13 when I copy your data to Excel and your last date 06-Jun copies over as 06/06/13
Should the first date be 14/06/12?

If so, does this work for you?.....

Sample Data...

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB
1	Quarter	1	1	1	1	1	1	1	1	1	1	1	1	1	2	2	2	2	2	2	2	2	2	2	2	2	2	3	3	3	3	3	3	3	3	3	3	3	3	3	4	4	4	4	4	4	4	4	4	4	4	4	4	*
2	Date	14-Jun	21-Jun	28-Jun	05-Jul	12-Jul	19-Jul	26-Jul	02-Aug	09-Aug	16-Aug	23-Aug	30-Aug	06-Sep	13-Sep	20-Sep	27-Sep	04-Oct	11-Oct	18-Oct	25-Oct	01-Nov	08-Nov	15-Nov	22-Nov	29-Nov	06-Dec	13-Dec	20-Dec	27-Dec	03-Jan	10-Jan	17-Jan	24-Jan	31-Jan	07-Feb	14-Feb	21-Feb	28-Feb	07-Mar	14-Mar	21-Mar	28-Mar	04-Apr	11-Apr	18-Apr	25-Apr	02-May	09-May	16-May	23-May	30-May	06-Jun	*
3	Ben	N	D	L	N	N	L	L	W	L	L	L	N	W	L	N	N	L	W	W	D	N	L	L	L	L	N	W	N	N	N	L	N	N	N	L	L	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
4	Chris	N	N	N	N	N	L	N	L	L	W	W	N	N	N	N	N	L	W	N	D	L	N	L	L	L	N	N	N	N	N	W	N	N	N	N	W	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
5	Sagar	N	D	L	W	N	N	L	W	W	N	L	L	W	N	D	N	N	N	L	D	W	L	W	W	L	N	N	N	N	N	N	N	N	W	W	W	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
6	Tom M	N	D	W	N	N	W	N	N	W	W	N	W	N	L	D	W	L	N	W	D	L	L	N	N	N	N	N	N	N	N	L	L	N	N	N	N	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
7	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
Sheet20

Example Results1...

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
7
8	From Date	01/06/2012	To Date	10/06/2013
9
10		W	D	L	N
11	Overall Totals	Total Wins	Total draws	Total losses	DNP	Total Games	Should Equal Game Week	Win %	Total Points	Average Points Per Game
12	Ben	5	2	15	14	22	36	22.73%	17	0.77
13	Chris	5	1	8	22	14	36	35.71%	16	1.14
14	Sagar	10	3	7	16	20	36	50.00%	33	1.65
15	Tom M	7	3	6	20	16	36	43.75%	24	1.50
16
Sheet20

Example Results2.....

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
7
8	From Date	01/06/2012	To Date	13/09/2012
9
10		W	D	L	N
11	Overall Totals	Total Wins	Total draws	Total losses	DNP	Total Games	Should Equal Game Week	Win %	Total Points	Average Points Per Game
12	Ben	2	1	7	4	10	14	20.00%	7	0.70
13	Chris	2	0	3	9	5	14	40.00%	6	1.20
14	Sagar	4	1	4	5	9	14	44.44%	13	1.44
15	Tom M	5	1	1	7	7	14	71.43%	16	2.29
16
Sheet20

I hope that works for you.

Ak

 

[PeterG83]

Wow, thanks Akashwani! I will try it and come back to you.

The fist date was the 14th June 2012 and it was the year after that.

 

[PeterG83]

This works, so thank you very much.

Could you confirm what the -- does in the formula below so that i can fully understand it please.

=SUMPRODUCT(--($B$2:$BA$2>=$B$8)*($B$2:$BA$2<=$D$8)*($A$3:$A$6=$A12)*($B$3:$BA$6=B$10))

Cheers
Pete

 

[Akashwani]

Hi Pete,

I'm pleased it worked for you and thanks for the feedback.

The double negative -- converts the TRUE and FALSE within the formula to 1's and 0's.

Excel SUMPRODUCT formula - Syntax, Usage, Examples and Tutorial | Chandoo.org - Learn Microsoft Excel Online

Ak

 

[PeterG83]

Thanks Ak.

I have another question.

I want to come up with a summary which shows all the partnerships of people and count wins together, draws together, losses when paired together. How would i go about doing this? The teams are mixed up each week into 5 on each team so a summary of best combinations of pairs would be useful.

Thank you
Pete

 

[Akashwani]

Hi Pete,

From your original data I cannot tell who was paired with who, so, if you can supply a sample of the data that will show the "Pairs" then I'm sure a solution can be found.

Ak

 

[PeterG83]

Basically there is a pool of players but only 10 people play each week and they are split into 2 teams of 5. So someone may play 3 weeks in a row then doesnt play for a few weeks, it also means some people might play 35 games a season or some might play 45 etc. I was wanting to find some way to show which partnerships of players win the most... Is this possible?

If you need anymore info let me know, hopefully you get where i am coming from!

Thanks
Pete

[TABLE="width: 1199"]
<COLGROUP><COL style="WIDTH: 159pt; mso-width-source: userset; mso-width-alt: 7753" width=212><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" span=16 width=86><TBODY>[TR]
[TD="class: xl69, width: 212, bgcolor: #c4bd97"]Players[/TD]
[TD="class: xl68, width: 86, bgcolor: #c4bd97"]14/06/2012[/TD]
[TD="class: xl68, width: 86, bgcolor: #c4bd97"]21/06/2012[/TD]
[TD="class: xl68, width: 86, bgcolor: #c4bd97"]28/06/2012[/TD]
[TD="class: xl68, width: 86, bgcolor: #c4bd97"]05/07/2012[/TD]
[TD="class: xl68, width: 86, bgcolor: #c4bd97"]12/07/2012[/TD]
[TD="class: xl68, width: 86, bgcolor: #c4bd97"]19/07/2012[/TD]
[TD="class: xl68, width: 86, bgcolor: #c4bd97"]26/07/2012[/TD]
[TD="class: xl68, width: 86, bgcolor: #c4bd97"]02/08/2012[/TD]
[TD="class: xl68, width: 86, bgcolor: #c4bd97"]09/08/2012[/TD]
[TD="class: xl68, width: 86, bgcolor: #c4bd97"]16/08/2012[/TD]
[TD="class: xl68, width: 86, bgcolor: #c4bd97"]23/08/2012[/TD]
[TD="class: xl68, width: 86, bgcolor: #c4bd97"]30/08/2012[/TD]
[TD="class: xl68, width: 86, bgcolor: #c4bd97"]06/09/2012[/TD]
[TD="class: xl68, width: 86, bgcolor: #c4bd97"]13/09/2012[/TD]
[TD="class: xl68, width: 86, bgcolor: #c4bd97"]20/09/2012[/TD]
[TD="class: xl68, width: 86, bgcolor: #c4bd97"]27/09/2012[/TD]
[/TR]
[TR]
[TD="class: xl70, width: 212, bgcolor: #c4bd97"]Ben[/TD]
[TD="class: xl67"]NG[/TD]
[TD="class: xl67"]D[/TD]
[TD="class: xl67"]L[/TD]
[TD="class: xl67"]N[/TD]
[TD="class: xl67"]NG[/TD]
[TD="class: xl67"]L[/TD]
[TD="class: xl67"]L[/TD]
[TD="class: xl67"]W[/TD]
[TD="class: xl67"]L[/TD]
[TD="class: xl67"]L[/TD]
[TD="class: xl67"]L[/TD]
[TD="class: xl67"]N[/TD]
[TD="class: xl67"]W[/TD]
[TD="class: xl67"]L[/TD]
[TD="class: xl67"]N[/TD]
[TD="class: xl67"]N[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Chris[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Sagar[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]D[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]D[/TD]
[TD="class: xl64"]N[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Tom M[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]D[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]D[/TD]
[TD="class: xl64"]W[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Hugo WS[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]D[/TD]
[TD="class: xl64"]L[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Pete R[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Nico[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]D[/TD]
[TD="class: xl64"]N[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Stefan[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]D[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]D[/TD]
[TD="class: xl64"]W[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Nick[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]D[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Grant[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]D[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Dan [/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]D[/TD]
[TD="class: xl64"]L[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Pete G[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]W[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Tom W[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]D[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]D[/TD]
[TD="class: xl64"]L[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Dave[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]L[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]D[/TD]
[TD="class: xl64"]L[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Will T[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]L[/TD]
[TD="class: xl65"]L[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]W[/TD]
[TD="class: xl65"]L[/TD]
[TD="class: xl65"]W[/TD]
[TD="class: xl65"]L[/TD]
[TD="class: xl65"]W[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]L[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Johnny B[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Gav[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Hugo S[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]L[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]W[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]L[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]W[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Freeman[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]W[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]W[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Rowson Jr[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[TD="class: xl64"]N[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Matt [/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]D[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]W[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]W[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]L[/TD]
[TD="class: xl65"]W[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]w[/TD]
[TD="class: xl65"]W[/TD]
[TD="class: xl65"]D[/TD]
[TD="class: xl65"]N[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Mark[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Jimmy[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]D[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]L[/TD]
[TD="class: xl65"]L[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]L[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Good Will[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]John[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]D[/TD]
[TD="class: xl65"]W[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]D[/TD]
[TD="class: xl65"]N[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Ross[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]L[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Chris S[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]L[/TD]
[TD="class: xl65"]W[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Chris (Chris S' mate)[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]L[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Alex Hurrel[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]L[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 212, bgcolor: #c4bd97"]Jonny Original[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl64"]NG[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[TD="class: xl65"]N[/TD]
[/TR]
</TBODY>[/TABLE]

 

[Akashwani]

Hi Pete,

I'm sorry, but from the above dated I cannot find a way of identifying the partnerships, Eg how many times did Ben, Chris, Sagar, Tom M and Hugo WS appear in the same partnership?

I think that this problem is way beyond my Excel knowledge and you may be best served by creating a new post.

Sorry that I couldn't be of more help to you Pete, but good luck.

Ak

 

[PeterG83]

No problem, thanks AK.

I have posted this question seperately.

Pete