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...
Thanks Anders, that worked, can't believe I couldn't figure that one out myself! 🙂 Maybe with the article I will be able to get it myself next ti...
This is great Mynda! Many thanks for taking the time to resolve this for me - very helpful. Alan
Hi Mynda, Many thanks as always for the help - it definitely gets me much closer to the filtering I was hoping to add to the table. I was hoping t...