# Posts by FrankieBue

• ## Last 6 matches home and away soccer form table

Re: Last 6 matches home and away soccer form table

hi nbvc,

In D column We have Home Teams ------- In F column We have Away Teams!!!
So there are many rows which contain Home and Away Teams… on the right of these,
in Q, R, S, T columns, there are some calculations about their results:
“ score or not, under over goals, both teams score… “

I want count in last six occurences, about last six league rounds, like shown in column B, as follows:

How many times a Home Team has scored or not ( column N) … so this for other Q, R, S, T
How many times an Away Team has scored or not ( column O) … so this for other Q, R, S, T

!!!!!!!!!!!!!!! All this about ONLY LAST SIX LEAGUE ROUNDS !!!!!!!!!!!!!!!!!!!!

For example in Italy Serie A league championship, like in column B,
from the first last round, the 19th, until the sixth last round, the 14th round…
by covering and taking always the last six occurences…
Z9: Inter played _4 games in home_ by scoring 4 times, like shown in Z:Z … ( 4 scored Yes)
Z9: Inter played _2 games away_ by scoring only 1 time and not scoring also 1 time ( 1 scored Yes & 1 Not)

By following these rules I want calculate what I explained, about all the observable league teams in Y:Y

Note Well:
In other leagues, expecially English leagues, when I refresh query web about new league championship results, I find postponed or abandoned games of previous league rounds which are replayed.
These replayed games are assorted, mixed to very last 6 played rounds…
According to my ideas They are calculated like lasts by me… and sometimes, by counting last six occurences of a Team, covering last six league rounds, we should find a Team which played also 5 times like Home and only 1 Away.

Hope I’ll be able to be helped,
I’M STUCK.

TAKE CARE.
Regards.
Luciano

• ## Last 6 matches home and away soccer form table

Re: Last 6 matches home and away soccer form table

dear last two kinds of formulas give me different results how you can calculate on attacked url file.

The first is good to calculate last six home+away.

Can t we solve lasts my question ???

Have a nice dinner.

See you
Take care.
Luciano

• ## Last 6 matches home and away soccer form table

Re: Last 6 matches home and away soccer form table

DEAR

i took error num in z:Z

[Blocked Image: http://i41.tinypic.com/30cqhqq.jpg]

i haven't yet try lasts formulas.

i saw *(\$K\$3:\$K\$870>0)

many thanks dear,

thanks of all.

take care,
regards.

luciano

• ## Last 6 matches home and away soccer form table

Re: Last 6 matches home and away soccer form table

No dear.

If you see Inter team, in d:d, in last six serie A rounds, inter played 4 games like home and 2 by away.

Otherwise i don't know what and how to expalain the last six games in last six rounds i want how to calculate statistics in last home and away games il last six rounds.

I hope you'll understand me.

Take care
Regards

• ## Last 6 matches home and away soccer form table

Re: Last 6 matches home and away soccer form table

hello mate.

thanks so much. you are the best!!! i don't know how to thanksgive you!!

Now i have a question about some mistakes by counting statistics... perhaps i apologized something:

for example by taking "INTER" in home... if i count Inter last games played in home to calculate "scored Yes", with your formulas, i'll see displayed it with three games in home, but inter played, in last six total games, 4 times in home and two games by away... how to correct and solve this mistake???

i want its last six games in order of the decrescending rounds played... week by week...

I want learn how i can count only the lasts six matches of a football Team "X".
It will play 4 matches in home and 2 away; it had played 3 matches in home and 3 away or it could have played 1 match in home and 5 away... i will want count always and only its six lasts matches to calculate some statistics.

thanks dear,

thanks of all.

take care,
regards.

luciano

• ## Last 6 matches home and away soccer form table

Hi all mates;
I hope you'll help me.
I want learn how i can count only the lasts six matches of a football Team "X".
It will play 4 matches in home and 2 away; it had played 3 matches in home and 3 away or it could have played 1 match in home and 5 away... i will want count always and only its six lasts matches to calculate some statistics.

[Blocked Image: http://i42.tinypic.com/346l4xs.jpg]

Kind regards.
See You