Wow, thanks very much, really appreciate you taking the time to help with this.

I've swotted up on array formulas but I still can't figure out how to expand the table if i have more data. Have tried just expanding all the cell refs and using ctrl+shft+ent but makes everything 100%.

Any light you can shed would be fantastic. I haven't sent the sheet as would really like to understand the process so can repeat it myself.

Thanks again