http://wikisend.com/download/370568/...ultimando.xlsm

Hello, I’m new to You All.
I don’t know how to set what I want.
By Thanksgiving in advance who will help me I put the idea I’m researching for:

In the attacked url file, I created a database, where I download soccer leagues results from lasts to firsts games played round order. I need of them to calculate some statistics shown in home away tables at least their lasts 6 games played… like visible in columns at the right of results columns.

http://i44.tinypic.com/3329kw5.jpg

I’m looking for a formula, which counts the firsts top three times when a soccer team is met like home in column D and like away in column F… so to calculate by owning to its result… a statistical tip/value I want.
A value defined by me, which is wanted in a column, where it is repeated consecutively in duplicate at each update….
Like you’ll see by downloading the attacked file and by helping me.
How can I count it for the firsts tops 3 times in an array that goes from ($ D $ 3: $ D $ 100,000 )
without restricting the arrays in which I’m looking for ???? example: $ D $ 3: $ D $ 68 $ N $ 3 : $ N $ 68
I have some functions switched on my worksheet, for example:
COUNTS . MORE . IF ($ D $ 3: $ D $ 68 AB3 ; $ N $ 3: $ N $ 68 "YES")
to be solved and translating in
COUNTS . MORE . IF ($ D $ 3: $ D $ 100000 AB3 ; $ N $ 3: $ N $ 100000 "YES") to count not “the all times”, but only the lasts three times in according to downloaded soccer leagues results from lasts to firsts games played round order, like shown in: OvGG!(A:F)
I ask help cause to:
At each update will vary rows and then I should be changing the final set of the array $ D $ 68 | $ N $ 68 cause to postponed or abandoned replayed matches results shown by downloading web query data.

I put you in my most total confidence ,
thanks in advance and infinitely effective collaboration .

God Bless YOU!

OFFICE 2010




For example:

A__B___C__________D____________E___________F_________ ( COLUMNS )

____________ANTONIO_____ - _________ROSALIA
____________SALVATORE__________ - _________ROSALIA
____________ANTONIO_____ - _________ROSALIA
____________ANTONIO_____ - _________ROSALIA
____________GIUSEPPE___________ - _________ROSALIA
____________ANTONIO_____ - _________ROSALIA
____________SALVATORE__________ - _________ROSALIA
____________ANTONIO_____ - _________ROSALIA
____________ANTONIO_____ - _________ROSALIA
____________GIUSEPPE___________ - _________ROSALIA
____________ANTONIO_____ - _________ROSALIA


ANTONIO is repeated 7 times in column (D: D)
how can I count it for the first 3 times in an array that
goes from ($ D $ 3: $ D $ 100,000 )

-> Without restricting the arrays in which I’m looking for ????



kind regards
luciano .