Thanks Very much Bebo, this does work and is definitely on the lines of what I am aiming for, however some of the results are not quite as expected:
My apologies. Where I have TEST SITE 1 this needs to be in the same cell for example, Newcastle Road
Also, I didn't want to put all of the column headers in my initial posting, but there are roughly the same amount of column headers again. Would I be able to amend your formulae for use with the additional column headers easy enough?
Many thanks for all your help
David
Bookmarks