brilliant. thank you very much for that.

If I wanted to use the same formula but on two of the columns (incase of inputting error with the invoice reference in G) do I just remove the references to this particular column?

Thanks.