Hi what i´m trying to do is counting how many times a club win, draw or loose, but i only want the last 4 results, not the whole count: i will place here an example:
This Formula is asking to count (A:A) DATE < DATE IN CELL A1;
(B:B) TEAM = TEAM IN CELL B1
(L:L) WIN DRAW OR LOOSE
(AC:AC) & (AD:AD) ARE THE FIELD FOR COUNTRY AND LEAGUE
This formula will tell me how many times that team have won before that date, but i only want the last 4,5 or 6 results.
Can someone tell me what to do. Thanks in advance.