A | B | C | D | E | F | |
1 | Home Team | Home Goals | - | Away Goals | Away Team | W-D-L<strike></strike> |
2 | NMFC | 2 | - | 1 | Chelsea | |
3 | NMFC | 3 | - | 1 | Norwich | |
4 | Liverpool | 3 | - | 2 | NMFC | |
5 | NMFC | 1 | - | 0 | Arsenal | |
6 | Manchester United | 2 | - | 1 | NMFC |
<tbody>
</tbody>
Hello, My table currently looks like the one above, I need a few formulas which hopefully I will learn from aswell as just putting in my spreadsheet.
First of All, I need "Column F" to determine whether NMFC have a Win, Draw or Loss (W-D-L)
Secondly, Possibly in "Cell G2" to calculate the Win Streak of which they are on now (most recent) plus highest number of Wins in a row NMFC have had in their History in "Cell G3"
And Finally In "Cell G4" is it possible to Create a Form sheet, looking up Criteria in the W-D-L Column, to give a result of the last 5 games, so from the table above it would appear as "WWLWL" with W being green, D being Orange and L being Red. (I don't know if that would be easier to make the W-D-L column results appearing in those colours, I could do that Column from conditional formatting if that isn't the easier option, "I" just don't know how to do it when they're all together
Thank You in advance