Hi Anders Further to your formula: I added an IFERROR function around your formula to handle the #N/A in the cells to tidy up the look of the sp...
Hello Anders Monday morning, just back at work. Thanks very much for your response, and it works great - thank you. Much easier than the way ...
Hello Anders Thank you for your response. I will take your spreadsheet to my colleague to see if it what they were after. Kind Regards, Gary
Maybe this post should have been put into the General section. Is it possible to have it moved please?
Hi Anders I have used the formula you provided and it works well. Thank you very much. Regards, gary
Hi Anders Thanks very much. I will check further and Yes it is what I am trying to achieve with a COUNTIFS statement. My goal was to improve an ...
Hi All Thanks for the replies to date. I have attached a copy of the original spreadsheet I am trying to rework and tidy up. The issue I am t...
Hi Clark That is really strange because the file I am trying to use definitely shows that sheet as password protected. I will use the file you h...
Hi Please find the attached spreadsheet. The Worksheet in particular that I cannot access is "Operation WWW"
Hi Mynda I will review the articles you have provided links to. Thanks for your advice, can I come back if I meet any issues? Gary