Forum

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...