Last 5 Results (footie)

[Patcheen]

How to find last 5 results

i have 2 criteria s in 2 columns

in G5:G500 (Won, Lost, Drew) in H5:H500 (Home, Away)

im trying to get the last 5 results

Example Home - Won (3) Drew (2) Lost (0) (See Pic)

in R6 i want 3

in S6 i want 2

in T6 i want 0

is this possible?

[Pete_UK]

It would help if you attached a sample Excel workbook, as many contributors are not able to view pictures due to software incompatibilities with some browsers.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Pete

[Patcheen]

I Have uploaded a example book hope it helps

[José Augusto]

Hi
Try this formula in F13 (valid to H13)

Please Login or Register  to view this content.

where $F11 is "Home", F$12 is "Won" (not "Won ")
You can copy the formula to F19:H19

See the file

[Patcheen]

i assume changing the 5 at the end to 10 would do 10 results

[José Augusto]

Yes. If you change last parameter of AGGREGATE function to 10 or other number.
Note that formula is good even if there are less games to count. You can SUM (Won, Lost, Drew) to get the total games counted.

[Patcheen]

Thank you José Augusto this works a treat...... Thank you

[José Augusto]

You are welcome.
Do not forget to mark the thread as SOLVED.