Hi,
Been struggling with this for a few days and given up. Hopefully you guys will help.
Basically, I want a column to recognise if another cell in the same row contains x then it will display Y
For instance, if B contains one of the cities, I want E to auto-populate the number for each
A...