Forum

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

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