Hello Aflatoon, SamT and Paul,

Thanks for all your input.

The suggested formula worked. I guess I had been staring at the screen for too long and missed the extra $ which made the whole reference absolute rather than just the row.

After coming back to the problem a few days later, I tried it and it worked.

Thanks again.