Last seen: Jun 5, 2026
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...
Many thanks Mynda, I will give it a go and let you know how I get on - thanks for always coming to the rescue! Cheers, Alan
Hi Mynda, Thanks for the explanation. Your comment made me realize that I could search for any text not just the delimiter I was using. All the u...
Hi Mynda/Sunny, thank you both for the help! Both the solutions appear to work on first try, I'll be building the sheet out a little later to will ...
Thanks Phil - that is the article I read - very useful!
Hi everyone, I finally took the time to use the resources on the website and managed to figure this one out for myself - progress! =IF(OR(LEFT(H...
Hi Phil, Many thanks for the response. I took your advice and started the process again using the Excel file as the starting point and building th...
