I have a list of football results
<tbody>
</tbody>
Stoke | 0 | 1 |
Aston Villa | 1 | 0 |
West Brom | 2 | 2 |
Sunderland | 2 | 2 |
West Ham | 0 | 1 |
Tottenham | 1 | 0 |
Arsenal | 2 | 1 |
Crystal Palace | 1 | 2 |
Man Utd | 1 | 2 |
Swansea | 2 | 1 |
Leicester | 2 | 2 |
These results continue and the team names appear over and over again. what I need is a formula to select for talk sake say 'Stoke'. and list everytime a result of theirs is listed, in order of the first that is listed to the last that is listed. There will be 38 in total. Note that I don't want to use a filter. The results are being pasted from a website so I want to formula to select each result for 'stoke'. |
<tbody>
</tbody>