Forum

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...

Hi Velouria, Sorry, but just realized that the sites are not always in the same order as in my example, Going forward I will be adding/removing sit...

Many thanks for your help Regards Paul

Hi Sunny, I have updated all 143,000 formulas and calc speed is back to normal Thanks for your help Regards Paul

Hi Sunny, Have removed the password, Thanks Paul

Hi Anders, I have noticed that after every action I do on my spreadsheet, in the Status Bar I get 'Calculating: (4 processor(s)): and there is a lo...

Thanks Anders

Many thanks Anders & Sunny very useful & informative solutions. Frans, we dived another set of 20 week figs by the total of 20 weeks occupa...

Thanks Sunny, I just forgot to do CTRL+SHIFT+ENTER instead of ENTER. when I put the formula in. Works perfect now. As usual you were a fantas...