Thanks for your suggestions. In the end I had to bite the bullet, and lose a couple of hours work. I now remember that in the morning I had a glitc...
Thanks for that Mynda. If I used Power BI, presumably anyone using the spreadsheet would need to have Power BI installed as well? Enjoy your bir...
Hello Catalin, Many thanks - there were some range names referring to an external workbook. I don't remember, but I probably moved (copied?) a s...
How did I know you'd say that.
I've found one basic mistake in that it was an array formula so I should have pressed CTRL-SHIFT-ENTER. I've also found a much simpler version whic...
Thanks for this, Derek.
SunnyKow said Hi Tim If that is what you want then I would suggest using a Pivot Table. Refer to my attachment. Sunny Kow Hello SunnyKow,...
Thanks Catalin, I'm not sure I follow you. Do I have to define another name with GET.CELL to deal with the row height property? What about th...
Thanks Catalin, I think you're going beyond the bounds of my Excel expertise - this reminds me of my Maths lecture days. I could always fol...