David, yes I was aware of this in Excel. Very helpful for people like me :~)
but I simply didn't have the time yesterday to look into it closely.

Luke, thanks again. I did have some abberant behaviour due to automatic
refreshing but I've simply set up your formula in a separate workbook linked
to my original data and it seems to work perfectly.

Best,

David