looking for help to improve this

[SERVECOLD]

https://spreadsheets.google.com/spr...xX-IddGNKejhteEdLa3gxMzdJdnJCd3ZEcGc&hl=en_US

 

[SERVECOLD]

in K column id like it to retreat the dates the games were played how would i do that would i use a lookup?

 

[SERVECOLD]

Excel Workbook
	B	C	D	E	F	G	H	I
2	20011-2012	P	W	D	L	F	A	Pts
3	Chelsea	6	6	0	0	17	0	18
4	Man City	6	3	2	1	7	5	11
Table

Excel 2002

Cell Formulas
Range	Formula
C3	=COUNTIF(Results!$C$2:$C$3000,"="&$B3)
C4	=COUNTIF(Results!$C$2:$C$3000,"="&$B4)
D3	=SUMPRODUCT(--(Results!$C$1:$C$3000=B3),--(Results!$E$1:$E$3000>Results!$F$1:$F$3000))
D4	=SUMPRODUCT(--(Results!$C$1:$C$3000=B4),--(Results!$E$1:$E$3000>Results!$F$1:$F$3000))
E3	=SUMPRODUCT(--(Results!$C$1:$C$3000=B3),--(Results!$E$1:$E$3000=Results!$F$1:$F$3000))
E4	=SUMPRODUCT(--(Results!$C$1:$C$3000=B4),--(Results!$E$1:$E$3000=Results!$F$1:$F$3000))
F3	=SUMPRODUCT(--(Results!$C$1:$C$3000=B3),--(Results!$E$1:$E$3000))
F4	=SUMPRODUCT(--(Results!$C$1:$C$3000=B4),--(Results!$E$1:$E$3000))
G3	=SUMIF(Results!$C:$C,"="&B3,Results!$E$1:$E$3000)
G4	=SUMIF(Results!$C:$C,"="&B4,Results!$E$1:$E$3000)
H3	=SUMIF(Results!$C$1:$C$3000,"="&B3,Results!$F$1:$F$3000)+SUMIF(Results!$D$1:$D$3000,"="&B3,Results!$C$1:$C$3000)
H4	=SUMIF(Results!$C$1:$C$3000,"="&B4,Results!$F$1:$F$3000)+SUMIF(Results!$D$1:$D$3000,"="&B4,Results!$C$1:$C$3000)
I3	=(D3*3)+E3
I4	=(D4*3)+E4

Excel Workbook
Name	Refers To
RESULT	=Results!$G$2:$G$390
Workbook Defined Names

thought i would add a few thing that i have found usefull in helping me create my football(soccer)league table

Excel Workbook
	K	L	M	N	O	P	Q
2	P	W	D	L	F	A	Pts
3	6	3	1	2	11	5	10
4	6	3	1	2	8	5	10
Table

Excel 2002

Cell Formulas
Range	Formula
K3	=COUNTIF(Results!$D$2:$D$3000,"="&B3)
K4	=COUNTIF(Results!$D$2:$D$3000,"="&B4)
L3	=SUMPRODUCT(--(Results!$D$1:$D$3000=B3),--(Results!$E$1:$E$3000))
L4	=SUMPRODUCT(--(Results!$D$1:$D$3000=B4),--(Results!$E$1:$E$3000))
M3	=SUMPRODUCT(--(Results!$D$1:$D$3000=B3),--(Results!$E$1:$E$3000=Results!$F$1:$F$3000))
M4	=SUMPRODUCT(--(Results!$D$1:$D$3000=B4),--(Results!$E$1:$E$3000=Results!$F$1:$F$3000))
N3	=SUMPRODUCT(--(Results!$D$1:$D$3000=B3),--(Results!$E$1:$E$3000>Results!$F$1:$F$3000))
N4	=SUMPRODUCT(--(Results!$D$1:$D$3000=B4),--(Results!$E$1:$E$3000>Results!$F$1:$F$3000))
O3	=SUMIF(Results!$D$1:$D$3000,"="&B3,Results!$F$1:$F$3000)
O4	=SUMIF(Results!$D$1:$D$3000,"="&B4,Results!$F$1:$F$3000)
P3	=SUMIF(Results!$D$1:$D$3000,"="&B3,Results!$E$1:$E$3000)
P4	=SUMIF(Results!$D$1:$D$3000,"="&B4,Results!$E$1:$E$3000)
Q3	=(L3*3)+M3
Q4	=(L4*3)+M4

Excel Workbook
Name	Refers To
RESULT	=Results!$G$2:$G$390
Workbook Defined Names

Excel Workbook
	S	T	U	V	W	X	Y
2	P	W	D	L	F	A	GD
3	12	9	1	2	28	5	23
4	12	6	3	3	15	10	5
Table

Excel 2002

Cell Formulas
Range	Formula
S3	=C3+K3
S4	=C4+K4
T3	=D3+L3
T4	=D4+L4
U3	=E3+M3
U4	=E4+M4
V3	=F3+N3
V4	=F4+N4
W3	=G3+O3
W4	=G4+O4
X3	=H3+P3
X4	=H4+P4
Y3	=W3-X3
Y4	=W4-X4

Excel Workbook
	Z	AA	AB	AC	AD
2	Pts	%		%
3	28	43	2.3	240	0.4
4	21	80	1.3	120	0.8
Table

Excel 2002

Cell Formulas
Range	Formula
Z3	=I3+Q3
Z4	=I4+Q4
AA3	=SUM(S3/W3)*100
AA4	=SUM(S4/W4)*100
AB3	=1/AA3*100
AB4	=1/AA4*100
AC3	=SUM(S3/X3)*100
AC4	=SUM(S4/X4)*100
AD3	=1/AC3*100
AD4	=1/AC4*100

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	Date	RND	HomeTeam	AwayTeam	FTHG	FTAG	RESULT	HTR	ATR	FTR
2	14.8.10	1	Tottenham	Man City	0	0	X	HD	AD	D
3	14.8.10	1	Aston V	West ham	3	0	1	HW	AL	H
Results

Excel 2002

Cell Formulas
Range	Formula
G2	=IF(E2>F2,"1",IF(E2E2=F2,"X",)))
G3	=IF(E3>F3,"1",IF(E3E3=F3,"X",)))
H2	=IF(E2>F2,"HW",IF(E2E2=F2,"HD",)))
H3	=IF(E3>F3,"HW",IF(E3E3=F3,"HD",)))
I2	=IF(E2>F2,"AL",IF(E2E2=F2,"AD",)))
I3	=IF(E3>F3,"AL",IF(E3E3=F3,"AD",)))
J2	=IF(E2>F2,"H",IF(E2E2=F2,"D",)))
J3	=IF(E3>F3,"H",IF(E3E3=F3,"D",)))

 

[SERVECOLD]

to sort the table drag my mouse over all of it then i open the data tab click sort then choose Z,Y,W enter