Hi Catalin, great to hear from you again! I am still using the query you helped me with every day 🙂 Your answer here worked a treat, thanks aga...
Hi Anders, Thanks so much for this, it works! I am happy to leave the cells when we are past those 1095 days without shading. The idea is we cat...
Hi Anders, Many thanks for the help with this one. I did try to use the formula you provided but I could not get it to generate the desired result...
Hi Phil, Thanks for the note and apologies for the confusing message. The values I listed are days, so the cell value will be the date they took t...
Great solutions guys, thank you both so much for the help!
Hi Sunny, Many thanks for your candid and insightful response. I like the idea that by helping others find answers you increase your own skills - ...
Hi Sunny, A huge help, many thanks. Applied to the bigger data set the calculations take a little time but the result is what I wanted - many than...
Hi Sunny, Excellent! Many thanks for the advice and for catching the importance of validating the "OR" statement before the "IF" which I missed. ...
Hi Sunny, Many thanks for the insight. I should be able to work this out but just to check for the example formula above would you split into the ...
Many thanks Sunny, it works perfectly of course! 🙂 So a very simple mistake from me in terms of the syntax, any advice on how best to solve that ...
Hi there, I am back on the "OR" trail, looking for help again. I have the formula below that does not work, (wrong syntax at least): =IF(OR(MAX...