Thanks Mynda I do use 365, Worked perfectly, Out of interest why not use INDIRECT? Regards Paul
Thanks Sunny Works perfectly Regards Paul
Hi Mynda, Thanks for the reply, Unfortunately the data does not come to me in Tabula layout. I am going to try and reformat the data into Tabula...
Many thanks for the help, I have learnt so much from the replies A big shout out to Philip, Purfleet, Anders & Velouria
Thank you for the update Regards Paul
Hi Anders, Sorry for not replying sooner, but work took over, Really great solution, but when I tried moving to a different position on spr...
Many thanks to Anders & Velouria Simple when you know how? Regards Paul
Hi Anders, I did try that using formula; =AVERAGEIF($E$4:$E$158,$C160,F$4:F$158,"<>0") but I get an error message that says 'You've entered t...