Hi Forum,
Please help with the attached work book,I just need the so called FORM which is Win/Draw/Loss of the last 10 games displayed next to the team horizontally.
The Wins/Draw/Loss for all the matches are formulated in columns J3:AC382 and conditionally formatted to fill the cells with red/grey and green.(At this stage of the season each team has played 3 games and the rest of the scores are generated randomly)
I want the last 10 games FORM Win/Draw/Loss to be displayed horizontally next to the league calculation table.Lets say for Arsenal beginning with row AP3:AY3 for their last 10 games and so on for the other teams in the table,
Cheers
Als
Bookmarks