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...
Hi Sunny, I'm still not able to get the formula to work on my worksheet? Is it because in my worksheet the Hotel column is before the Hotel Group c...
Hi Sunny, I tried applying the formula to my spreadsheet but could not get it to work, not sure if the issue is because the lookup values are on an...
Thanks Sunny Great help
Thanks Sunny