looking for help to improve this

[SERVECOLD]

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

 

[Michael M]

Hi
It might help if you give us a clue as to what you want to achieve.
Also, quite a number of posters won't bother to look at upload sites, so if you can post an example here it will expand your number of posters looking to help.

 

[SERVECOLD]

first is it possible to get the data on sheet 2 to be in 1 column also been trying to get this to work
=INDEX(B2:B13,COUNT(B2:B13)-F1+1):INDEX(B2:B13,COUNT(B2:B13))
F1 being a number 1-6 which will count the last 6 results or which ever number i choose
also on sheet 1 i have been trying to have a drop down list of the teams
so that i can return how many game the choosen teams have played at home+the results in columns G,H,I,J but still no look in getting it to work thanks SC

thanks M i havent been on in a while will try an look at doing that in morning

 

[SERVECOLD]

cant get me head round that HTML thingy to tired will try again in the morning
and hopefully be more clearer as what i would like it to do column letters an cells bbt

 

[SERVECOLD]

hi i have downloaded the html tool its on my tool bar in excel but when i click it nothing happens ? the mrexcel 1

 

[MARK858]

After clicking Generate HTML(usedefault), just paste in the reply message box (then click Go Advanced followed by preview post and it should appear)

 

[SERVECOLD]

Excel Workbook
	A	B	C
1	ROUND	Tottenham	Tottenham
2	1	HD
3	2		AW
Round

Excel 2002

Cell Formulas
Range	Formula
B1	='Calc%'!$A$2
C1	='Calc%'!$A$2
C2	=IF(ISERROR(MATCH($C$1&$A2,Results!$D$2:$D$3000&Results!$B$2:$B$3000,0)),"",INDEX(Results!$I$2:$I$3000,MATCH($C$1&$A2,Results!$D$2:$D$3000&Results!$B$2:$B$3000,0)))

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

 

[SERVECOLD]

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
4	14.8.10	1	Blackburn	Everton	1	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",)))
G4	=IF(E4>F4,"1",IF(E4E4=F4,"X",)))
H2	=IF(E2>F2,"HW",IF(E2E2=F2,"HD",)))
H3	=IF(E3>F3,"HW",IF(E3E3=F3,"HD",)))
H4	=IF(E4>F4,"HW",IF(E4E4=F4,"HD",)))
I2	=IF(E2>F2,"AL",IF(E2E2=F2,"AD",)))
I3	=IF(E3>F3,"AL",IF(E3E3=F3,"AD",)))
I4	=IF(E4>F4,"AL",IF(E4E4=F4,"AD",)))
J2	=IF(E2>F2,"H",IF(E2E2=F2,"D",)))
J3	=IF(E3>F3,"H",IF(E3E3=F3,"D",)))
J4	=IF(E4>F4,"H",IF(E4E4=F4,"D",)))

 

[SERVECOLD]

thanks mark
see if i can explain myself
right on the round sheet id like just 2 columns A&B so c3 would be in b3 their 38 rounds in total an ive played around with the formula but cant get it to work
also is it possible to put a drop down menu with the teams so every time i put a new team in from the result sheet it pulls out all the times that team appears in column c the hometeam +columns d,e,f,g,h,and i
tried the podcast but because i dont know the terms to use it hard to know what to look for thanks SC

 

[SERVECOLD]

ok found this on excel is fun
think its what im after

http://www.youtube.com/user/ExcelIsFun#p/search/3/6bGKhbUYOas

Excel Workbook
	K	L	M	N	O	P	Q	R	S	T
1	Arsenal	6
2	Date	RND	HomeTeam	AwayTeam	FTHG	FTAG	RESULT	HTR	ATR	FTR
3		1	Arsenal	Blackpool	6	0	1	HW	AL	H
Results

Excel 2002

Cell Formulas
Range	Formula
L1	=COUNTIF(HomeTeam,K1)

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

Excel Workbook
Name	Refers To
HomeTeam	=Results!$C$2:$C$390
Workbook Defined Names

seek an tho shall find without mrexcel an excel is fun dont know what id do