PedroGomez9
New Member
- Joined
- Feb 25, 2021
- Messages
- 6
- Office Version
- 2016
- Platform
- Windows
Hi guys
I have a list of sporting results, and I'm trying to put a TRUE/FALSE on whether or not it's one of the team's last 'x' (user-defined, changeable value) games - they can appear in either Column A or Column B.
I have a helper column, lets call it C1 for arguments sake with the user defined value of games I'm looking to isolate.
I have a list of sporting results, and I'm trying to put a TRUE/FALSE on whether or not it's one of the team's last 'x' (user-defined, changeable value) games - they can appear in either Column A or Column B.
I have a helper column, lets call it C1 for arguments sake with the user defined value of games I'm looking to isolate.
HomeTeam | AwayTeam |
Watford | Middlesbrough |
Fulham | Arsenal |
Birmingham | Brentford |
Wycombe | Rotherham |
Crystal Palace | Southampton |
Barnsley | Luton |
Bournemouth | Blackburn |
Bristol City | Coventry |
Cardiff | Sheffield Weds |
Derby | Reading |
Huddersfield | Norwich |
Millwall | Stoke |
Preston | Swansea |
QPR | Nott'm Forest |
Accrington | Peterboro |
Crewe | Charlton |
Doncaster | Milton Keynes Dons |
Fleetwood Town | Burton |
Gillingham | Hull |
Lincoln | Oxford |
Northampton | AFC Wimbledon |
Plymouth | Blackpool |
Portsmouth | Shrewsbury |
Sunderland | Bristol Rvs |
Swindon | Rochdale |
Barrow | Stevenage |
Bolton | Forest Green |
Bradford | Colchester |
Cambridge | Carlisle |
Cheltenham | Morecambe |
Mansfield | Tranmere |
Oldham | Leyton Orient |
Port Vale | Crawley Town |
Salford | Exeter |
Scunthorpe | Newport County |
Southend | Harrogate |
Walsall | Grimsby |
Liverpool | Leeds |
West Ham | Newcastle |
Ipswich | Wigan |
West Brom | Leicester |
Tottenham | Everton |
Sheffield United | Wolves |
Brighton | Chelsea |
Coventry | QPR |
Everton | West Brom |
Nott'm Forest | Cardiff |
Carlisle | Southend |
Leeds | Fulham |
Blackburn | Wycombe |
Brentford | Huddersfield |
Luton | Derby |
Middlesbrough | Bournemouth |
Norwich | Preston |
Reading | Barnsley |
Rotherham | Millwall |
Sheffield Weds | Watford |
Swansea | Birmingham |
AFC Wimbledon | Plymouth |
Blackpool | Swindon |
Bristol Rvs | Ipswich |
Burton | Accrington |
Charlton | Doncaster |
Hull | Crewe |
Milton Keynes Dons | Lincoln |
Oxford | Sunderland |
Peterboro | Fleetwood Town |
Shrewsbury | Northampton |
Wigan | Gillingham |
Colchester | Bolton |
Crawley Town | Scunthorpe |
Exeter | Port Vale |
Forest Green | Bradford |
Grimsby | Salford |
Harrogate | Walsall |
Leyton Orient | Mansfield |
Morecambe | Cambridge |
Newport County | Barrow |
Stevenage | Oldham |
Tranmere | Cheltenham |
Man United | Crystal Palace |
Arsenal | West Ham |
Southampton | Tottenham |
Newcastle | Brighton |
Stoke | Bristol City |
Rochdale | Portsmouth |
Chelsea | Liverpool |
Leicester | Burnley |
Aston Villa | Sheffield United |
Wolves | Man City |
Huddersfield | Nott'm Forest |
Brighton | Man United |
Watford | Luton |
Wycombe | Swansea |
Crystal Palace | Everton |
Barnsley | Coventry |
Birmingham | Rotherham |
Cardiff | Reading |
Derby | Blackburn |