I am looking for a formula to solve the following problem. Say I have a data range of A2:A6
<tbody>
Cell (A1)
Name
A2
Manchester, UK | Chester, UK
A3
Chester
A4
Manchester, UK
A5
Chesterfield, UK
A6
Chester, UK
</tbody>
I would like for the result to be '3' as Chester is in A2, A3...