Forum

Hi Velouria, Yes, formula works perfectly, I forgot INDEX as rarely use it. Thank you so much for your help. Regards Paul

Thanks Velouria Works perfectly Regards Paul

Hi Formula worked fine until Week number changes to start with 2, then result is wrong? I can't work out what has gone wrong< any help greatl...

Thanks Mynda

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