Win Loss Draw streak for last 10 games for ladder

Hey guys. I am trying to incorporate a win/loss/draw streak column into a fantasy sports competition.
As you will probably see I've adapted other formulas from this site to suit my needs however i just cant seem to find one that will sort this one out..

On the Results tab you will see head to head matches of all the teams in this competition.
What I'd like is their last 5 results on the Ladder TAB in the AD column
.
I'd like it to look like (without the W L D) SO 7 1 2 OR 5 3 2 Etc Etc
W L D
5 4 1

Hopefully you understand what im after.

Thanks for reading my post either way...

I'm getting "Unreadable content", corrupt file perhaps?

Your file is too big for me!

If you can make up a small file with about 20 rows and as few columns as possible worth of data I'll take a look. In an *.xlsx format file that would be about 10kb in size.

Make sure you show us what results you expect.

ladder template.xlsx ive made it as small as i possible could
ps thanks for the reply and the offer to help

I don't think you'll be able to get the results in a single cell without using a VBA function.

I'm not much of a programmer so I can't help in that direction.

Even if you use formulas and put the results in separate cells it's still going to be very complicated due to the data structure.

What do you want to do?

You're welcome!

Good luck!

Hi

Only took less than 10 minutes

Need set up Dummy!!

use COUNTIF like this Results page cell M4

Formula:

Please Login or Register  to view this content.

See <=5 mean last 5 game you can change it to <=10 last 10 game.

See the file!

Regard
micope21

Click Thread Tools above your first post, select "Mark your thread as Solved".