Last seen: Jun 5, 2026
Hi Mynda, Many thanks for the advice. I did an internet search and found a couple of videos that were very helpful with getting the data required ...
Hi Phil, Perfect reply! Many thanks for taking the time to walk me through your approach and for providing the links etc. Plenty for me to work o...
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...