Spreadsheet: 742092d1627518304-current-streak-adding-ties-and-changing-to-numerical-streakchanges
Sheet: Sheet1

Home Team | Away Team | Home Goals | Away Goals | HOME RESULT | AWAY RESULT | WINNER | LOSER |  |  |  |  | CHANGE #1 | CHANGE #2
Fulham | Arsenal | 0 | 3 |  |  |  |  |  |  | Arsenal |  |  | 3
Crystal Palace | Southampton | 1 | 0 |  |  |  |  |  |  | [NAME] |  |  | -2
Liverpool | [NAME] | 4 | 3 |  |  |  |  |  |  | Brighton |  |  | -1
West Ham Utd | Newcastle Utd | 0 | 2 |  |  |  |  |  |  | Burnley |  |  | -1
West Brom | Leicester City | 0 | 3 |  |  |  |  |  |  | Chelsea |  |  | -1
Tottenham | Everton | 0 | 1 |  |  |  |  |  |  | Crystal Palace |  |  | 1
Sheffield Utd | Wolverhampton | 0 | 2 |  |  |  |  |  |  | Everton |  |  | -1
Brighton | Chelsea | 1 | 3 |  |  |  |  |  |  | Fulham
Everton | West Brom | 5 | 2 |  |  |  |  |  |  | [NAME]
[NAME] | Fulham | 4 | 3 |  |  |  |  |  |  | Leicester City
[NAME] | Crystal Palace | 1 | 3 |  |  |  |  |  |  | Liverpool
Arsenal | West Ham Utd | 2 | 1 |  |  |  |  |  |  | Manchester City
Southampton | Tottenham | 2 | 5 |  |  |  |  |  |  | [NAME]
Newcastle Utd | Brighton | 0 | 3 |  |  |  |  |  |  | Newcastle Utd
Chelsea | Liverpool | 0 | 2 |  |  |  |  |  |  | Sheffield Utd
Leicester City | Burnley | 4 | 2 |  |  |  |  |  |  | Southampton
[NAME] | Sheffield Utd | 1 | 0 |  |  |  |  |  |  | Tottenham
Wolverhampton | Manchester City | 1 | 3 |  |  |  |  |  |  | West Brom
Brighton | [NAME] | 2 | 3 |  |  |  |  |  |  | West Ham Utd
Crystal Palace | Everton | 1 | 2 |  |  |  |  |  |  | Wolverhampton
West Brom | Chelsea | 3 | 3 |  |  |  |  |  |  |  |  |  | ^^^this is what I'm looking for
Burnley | Southampton | 0 | 1
Sheffield Utd | [NAME] | 0 | 1 |  |  |  |  |  |  | 2 changes I am looking for:
Tottenham | Newcastle Utd | 1 | 1 |  |  |  |  |  |  | Change #1 > | how do I get TIE'S to show up for Streak. Its showing up as an extension of wins or losses
Manchester City | Leicester City | 2 | 5 |  |  |  |  |  |  | Change #2 > | how do I get a numerical data for streak, for example its showing up as 3W, 2L,…but I want it to show up as 3, or -2,etc
West Ham Utd | Wolverhampton | 4 | 0
Fulham | [NAME] | 0 | 3
Liverpool | Arsenal | 3 | 1
Chelsea | Crystal Palace | 4 | 0
Everton | Brighton | 4 | 2
[NAME] | Manchester City | 1 | 1
Newcastle Utd | Burnley | 3 | 1
Leicester City | West Ham Utd | 0 | 3
Southampton | West Brom | 2 | 0
Arsenal | Sheffield Utd | 2 | 1
Wolverhampton | Fulham | 1 | 0
[NAME] | Tottenham | 1 | 6
[NAME] | Liverpool | 7 | 2
Everton | Liverpool | 2 | 2
Chelsea | Southampton | 3 | 3
Manchester City | Arsenal | 1 | 0
Newcastle Utd | [NAME] | 1 | 4
Sheffield Utd | Fulham | 1 | 1
Crystal Palace | Brighton | 1 | 1
Tottenham | West Ham Utd | 3 | 3
Leicester City | [NAME] | 0 | 1
West Brom | Burnley | 0 | 0
[NAME] | Wolverhampton | 0 | 1
[NAME] | [NAME] | 0 | 3
West Ham Utd | Manchester City | 1 | 1
Fulham | Crystal Palace | 1 | 2
[NAME] | Chelsea | 0 | 0
Liverpool | Sheffield Utd | 2 | 1
Southampton | Everton | 2 | 0
Wolverhampton | Newcastle Utd | 1 | 1
Arsenal | Leicester City | 0 | 1
Brighton | West Brom | 1 | 1
Burnley | Tottenham | 0 | 1
Wolverhampton | Crystal Palace | 2 | 0
Sheffield Utd | Manchester City | 0 | 1
Burnley | Chelsea | 0 | 3
Liverpool | West Ham Utd | 2 | 1
[NAME] | Southampton | 3 | 4
Newcastle Utd | Everton | 2 | 1
[NAME] | Arsenal | 0 | 1
Tottenham | Brighton | 2 | 1
Fulham | West Brom | 2 | 0
[NAME] | Leicester City | 1 | 4
Brighton | Burnley | 0 | 0
Southampton | Newcastle Utd | 2 | 0
Everton | [NAME] | 1 | 3
Crystal Palace | [NAME] | 4 | 1
Chelsea | Sheffield Utd | 4 | 1
West Ham Utd | Fulham | 1 | 0
West Brom | Tottenham | 0 | 1
Leicester City | Wolverhampton | 1 | 0
Manchester City | Liverpool | 1 | 1
Arsenal | [NAME] | 0 | 3
Newcastle Utd | Chelsea | 0 | 2
[NAME] | Brighton | 1 | 2
Tottenham | Manchester City | 2 | 0
[NAME] | West Brom | 1 | 0
Fulham | Everton | 2 | 3
Sheffield Utd | West Ham Utd | 0 | 1
[NAME] | Arsenal | 0 | 0
Liverpool | Leicester City | 3 | 0
Burnley | Crystal Palace | 1 | 0
Wolverhampton | Southampton | 1 | 1
Crystal Palace | Newcastle Utd | 0 | 2
Brighton | Liverpool | 1 | 1
Manchester City | Burnley | 5 | 0
Everton | [NAME] | 0 | 1
West Brom | Sheffield Utd | 1 | 0
Southampton | [NAME] | 2 | 3
Chelsea | Tottenham | 0 | 0
Arsenal | Wolverhampton | 1 | 2
Leicester City | Fulham | 1 | 2
West Ham Utd | [NAME] | 2 | 1
Burnley | Everton | 1 | 1
Manchester City | Fulham | 2 | 0
West Ham Utd | [NAME] | 1 | 3
Chelsea | [NAME] | 3 | 1
West Brom | Crystal Palace | 1 | 5
Sheffield Utd | Leicester City | 1 | 2
Tottenham | Arsenal | 2 | 0
Liverpool | Wolverhampton | 4 | 0
Brighton | Southampton | 1 | 2
[NAME] | West Ham Utd | 1 | 2
Wolverhampton | [NAME] | 0 | 1
Newcastle Utd | West Brom | 2 | 1
[NAME] | Manchester City | 0 | 0
Everton | Chelsea | 1 | 0
Southampton | Sheffield Utd | 3 | 0
Crystal Palace | Tottenham | 1 | 1
Fulham | Liverpool | 1 | 1
Arsenal | Burnley | 0 | 1
Leicester City | Brighton | 3 | 0
Wolverhampton | Chelsea | 2 | 1
Manchester City | West Brom | 1 | 1
Arsenal | Southampton | 1 | 1
[NAME] | Newcastle Utd | 5 | 2
Leicester City | Everton | 0 | 2
Fulham | Brighton | 0 | 0
Liverpool | Tottenham | 2 | 1
West Ham Utd | Crystal Palace | 1 | 1
[NAME] | Burnley | 0 | 0
Sheffield Utd | [NAME] | 2 | 3
Crystal Palace | Liverpool | 0 | 7
Southampton | Manchester City | 0 | 1
Everton | Arsenal | 2 | 1
Newcastle Utd | Fulham | 1 | 1
Brighton | Sheffield Utd | 1 | 1
Tottenham | Leicester City | 0 | 2
[NAME] | [NAME] | 6 | 2
West Brom | [NAME] | 0 | 3
Burnley | Wolverhampton | 2 | 1
Chelsea | West Ham Utd | 3 | 0
Leicester City | [NAME] | 2 | 2
[NAME] | Crystal Palace | 3 | 0
Fulham | Southampton | 0 | 0
Arsenal | Chelsea | 3 | 1
Manchester City | Newcastle Utd | 2 | 0
Sheffield Utd | Everton | 0 | 1
[NAME] | Burnley | 1 | 0
West Ham Utd | Brighton | 2 | 2
Liverpool | West Brom | 1 | 1
Wolverhampton | Tottenham | 1 | 1
Crystal Palace | Leicester City | 1 | 1
Chelsea | [NAME] | 1 | 1
Brighton | Arsenal | 0 | 1
Burnley | Sheffield Utd | 1 | 0
Southampton | West Ham Utd | 0 | 0
West Brom | [NAME] | 0 | 5
[NAME] | Wolverhampton | 1 | 0
Newcastle Utd | Liverpool | 0 | 0
Everton | West Ham Utd | 0 | 1
[NAME] | [NAME] | 2 | 1
Tottenham | [NAME] | 3 | 0
Crystal Palace | Sheffield Utd | 2 | 0
Brighton | Wolverhampton | 3 | 3
West Brom | Arsenal | 0 | 4
Newcastle Utd | Leicester City | 1 | 2
Chelsea | Manchester City | 1 | 3
Southampton | Liverpool | 1 | 0
Sheffield Utd | Newcastle Utd | 1 | 0
Burnley | [NAME] | 0 | 1
Wolverhampton | Everton | 1 | 2
Manchester City | Brighton | 1 | 0
Tottenham | Fulham | 1 | 1
Arsenal | Crystal Palace | 0 | 0
Wolverhampton | West Brom | 2 | 3
[NAME] | Brighton | 0 | 1
West Ham Utd | Burnley | 1 | 0
Fulham | Chelsea | 0 | 1
Leicester City | Southampton | 2 | 0
Sheffield Utd | Tottenham | 1 | 3
Liverpool | [NAME] | 0 | 0
Manchester City | Crystal Palace | 4 | 0
Arsenal | Newcastle Utd | 3 | 0
West Ham Utd | West Brom | 2 | 1
Leicester City | Chelsea | 2 | 0
Manchester City | [NAME] | 2 | 0
Fulham | [NAME] | 1 | 2
Liverpool | Burnley | 0 | 1
[NAME] | Newcastle Utd | 2 | 0
Crystal Palace | West Ham Utd | 2 | 3
Newcastle Utd | [NAME] | 1 | 2
Southampton | Arsenal | 1 | 3
West Brom | Manchester City | 0 | 5
Burnley | [NAME] | 3 | 2
Chelsea | Wolverhampton | 0 | 0
Brighton | Fulham | 0 | 0
Everton | Leicester City | 1 | 1
[NAME] | Sheffield Utd | 1 | 2
Tottenham | Liverpool | 1 | 3
Everton | Newcastle Utd | 0 | 2
Crystal Palace | Wolverhampton | 1 | 0
Manchester City | Sheffield Utd | 1 | 0
West Brom | Fulham | 2 | 2
Arsenal | [NAME] | 0 | 0
Southampton | [NAME] | 0 | 1
Chelsea | Burnley | 2 | 0
Leicester City | [NAME] | 1 | 3
West Ham Utd | Liverpool | 1 | 3
Brighton | Tottenham | 1 | 0
Sheffield Utd | West Brom | 2 | 1
Wolverhampton | Arsenal | 2 | 1
[NAME] | Southampton | 9 | 0
Newcastle Utd | Crystal Palace | 1 | 2
Burnley | Manchester City | 0 | 2
Fulham | Leicester City | 0 | 2
[NAME] | Everton | 1 | 2
[NAME] | West Ham Utd | 1 | 3
Liverpool | Brighton | 0 | 1
Tottenham | Chelsea | 0 | 1
[NAME] | Arsenal | 1 | 0
Burnley | Brighton | 1 | 1
Newcastle Utd | Southampton | 3 | 2
Fulham | West Ham Utd | 0 | 0
[NAME] | Everton | 3 | 3
Tottenham | West Brom | 2 | 0
Wolverhampton | Leicester City | 0 | 0
Liverpool | Manchester City | 1 | 4
Sheffield Utd | Chelsea | 1 | 2
[NAME] | Crystal Palace | 2 | 0
Leicester City | Liverpool | 3 | 1
Crystal Palace | Burnley | 0 | 3
Manchester City | Tottenham | 3 | 0
Brighton | [NAME] | 0 | 0
Southampton | Wolverhampton | 1 | 2
West Brom | [NAME] | 1 | 1
Arsenal | [NAME] | 4 | 2
Everton | Fulham | 0 | 2
West Ham Utd | Sheffield Utd | 3 | 0
Chelsea | Newcastle Utd | 2 | 0
Burnley | Fulham | 1 | 1
Everton | Manchester City | 1 | 3
Wolverhampton | [NAME] | 1 | 0
Southampton | Chelsea | 1 | 1
Burnley | West Brom | 0 | 0
Liverpool | Everton | 0 | 2
Fulham | Sheffield Utd | 1 | 0
West Ham Utd | Tottenham | 2 | 1
[NAME] | Leicester City | 1 | 2
Arsenal | Manchester City | 0 | 1
[NAME] | Newcastle Utd | 3 | 1
Brighton | Crystal Palace | 1 | 2
[NAME] | Southampton | 3 | 0
Manchester City | West Ham Utd | 2 | 1
West Brom | Brighton | 1 | 0
[NAME] | [NAME] | 0 | 1
Newcastle Utd | Wolverhampton | 1 | 1
Crystal Palace | Fulham | 0 | 0
Leicester City | Arsenal | 1 | 3
Tottenham | Burnley | 4 | 0
Chelsea | [NAME] | 0 | 0
Sheffield Utd | Liverpool | 0 | 2
Manchester City | Wolverhampton | 4 | 1
Burnley | Leicester City | 1 | 1
Sheffield Utd | [NAME] | 1 | 0
Crystal Palace | [NAME] | 0 | 0
Fulham | Tottenham | 0 | 1
West Brom | Everton | 0 | 1
Liverpool | Chelsea | 0 | 1
Burnley | Arsenal | 1 | 1
Sheffield Utd | Southampton | 0 | 2
[NAME] | Wolverhampton | 0 | 0
Brighton | Leicester City | 1 | 2
West Brom | Newcastle Utd | 0 | 0
Liverpool | Fulham | 0 | 1
Manchester City | [NAME] | 0 | 2
Tottenham | Crystal Palace | 4 | 1
Chelsea | Everton | 2 | 0
West Ham Utd | [NAME] | 2 | 0
Manchester City | Southampton | 5 | 2
Newcastle Utd | [NAME] | 1 | 1
[NAME] | Chelsea | 0 | 0
Crystal Palace | West Brom | 1 | 0
Everton | Burnley | 1 | 2
Fulham | Manchester City | 0 | 3
Southampton | Brighton | 1 | 2
Leicester City | Sheffield Utd | 5 | 0
Arsenal | Tottenham | 2 | 1
[NAME] | West Ham Utd | 1 | 0
Wolverhampton | Liverpool | 0 | 1
Fulham | [NAME] | 1 | 2
Brighton | Newcastle Utd | 3 | 0
West Ham Utd | Arsenal | 3 | 3
[NAME] | Tottenham | 0 | 2
Chelsea | West Brom | 2 | 5
[NAME] | Sheffield Utd | 2 | 1
Leicester City | Manchester City | 0 | 2
Arsenal | Liverpool | 0 | 3
Southampton | Burnley | 3 | 2
Newcastle Utd | Tottenham | 2 | 2
[NAME] | Fulham | 3 | 1
[NAME] | Brighton | 2 | 1
Everton | Crystal Palace | 1 | 1
Wolverhampton | West Ham Utd | 2 | 3
Fulham | Wolverhampton | 0 | 1
Manchester City | [NAME] | 1 | 2
Liverpool | [NAME] | 2 | 1
Crystal Palace | Chelsea | 1 | 4
Burnley | Newcastle Utd | 1 | 2
West Ham Utd | Leicester City | 3 | 2
Tottenham | [NAME] | 1 | 3
Sheffield Utd | Arsenal | 0 | 3
West Brom | Southampton | 3 | 0
Brighton | Everton | 0 | 0
Everton | Tottenham | 2 | 2
Newcastle Utd | West Ham Utd | 3 | 2
Wolverhampton | Sheffield Utd | 1 | 0
Arsenal | Fulham | 1 | 1
[NAME] | Burnley | 3 | 1
[NAME] | Liverpool | 1 | 1
Chelsea | Brighton | 0 | 0
Tottenham | Southampton | 2 | 1
[NAME] | Manchester City | 1 | 2
Leicester City | West Brom | 3 | 0
Arsenal | Everton | 0 | 1
Liverpool | Newcastle Utd | 1 | 1
West Ham Utd | Chelsea | 0 | 1
Sheffield Utd | Brighton | 1 | 0
Wolverhampton | Burnley | 0 | 4
[NAME] | [NAME] | 0 | 0
[NAME] | West Brom | 2 | 2
Leicester City | Crystal Palace | 2 | 1
Southampton | Leicester City | 1 | 1
Crystal Palace | Manchester City | 0 | 2
Brighton | [NAME] | 2 | 0
Chelsea | Fulham | 2 | 0
Everton | [NAME] | 1 | 2
Newcastle Utd | Arsenal | 0 | 2
Tottenham | Sheffield Utd | 4 | 0
West Brom | Wolverhampton | 1 | 1
Burnley | West Ham Utd | 1 | 2
Leicester City | Newcastle Utd | 2 | 4
[NAME] | Tottenham | 3 | 1
Sheffield Utd | Crystal Palace | 0 | 2
Manchester City | Chelsea | 1 | 2
Liverpool | Southampton | 2 | 0
Wolverhampton | Brighton | 2 | 1
[NAME] | [NAME] | 1 | 3
West Ham Utd | Everton | 0 | 1
Arsenal | West Brom | 3 | 1
Fulham | Burnley | 0 | 2
[NAME] | Leicester City | 1 | 2
Southampton | Crystal Palace | 3 | 1
Chelsea | Arsenal | 0 | 1
[NAME] | Everton | 0 | 0
[NAME] | Liverpool | 2 | 4
Newcastle Utd | Manchester City | 3 | 4
Burnley | [NAME] | 0 | 4
Southampton | Fulham | 3 | 1
Brighton | West Ham Utd | 1 | 1
Crystal Palace | [NAME] | 3 | 2
Tottenham | Wolverhampton | 2 | 0
West Brom | Liverpool | 1 | 2
Everton | Sheffield Utd | 0 | 1
[NAME] | Fulham | 1 | 1 |  |  |  |  | <<<Tie's are not showing up for STREAK