Thanks Pete, I did try it like that as well but had exactly the same outcome.
Equally, when trying it like that on a new spreadsheet it worked!!