Forum

Thanks Sunny Issue solved, fantastic help Regards Paul

Hi Sunny, Really sorry but have found an issue, when I updated the other columns to have W1, W2, W3 etc the formula does not work as it does not re...

Thanks Sunny, You are a star!!! Regards Paul

sorry forgot to attach file

Hi Sunny, Thanks for the reply, however unable to make the formula work due to how the info is laid out, have attached a 'clean' version of the rep...

Thank you Sunny & Clark for giving me the answer with different solutions, great, gives me options plus have learned a lot Regards Paul

Thank you Clark, I now totally understand where I was going wrong Regards Paul

Thanks Clark, I can see I was nearly there, so I can understand for the future what does adding the & before BG2 do? Thanks Paul

Thanks, formula works fine Regards Paul