Hi again,
Sorry to post but after hours on the internet and no luck I thought I'd chance my arm back at these forums because they provided me with so much joy the first time I posted.
It's hard to put into words exactly what I need but I have attached an example SS to visible show this.
Basically I'm looking for a tweak to my formula so that it can search a column of data and look for two separate phrases and if it finds either to provide the MID data from the relevant lines. (Which in my case is a time)
I have created a formula that does what I want when only one phrase is being searched, but I'm stumped about expanding this for two phases. (I have tried '{}' in my SEARCH formula without success. I have also tried to use AND and OR formulas without it working)
Current Formula that works for one search phrase:
=INDEX(MID(FILTER(A:A,ISNUMBER(SEARCH("multirec ended",A:A))),12,8),SEQUENCE(A2))
Attempted Formula that doesn't seem to work
=INDEX(MID(FILTER(A:A,ISNUMBER(OR(SEARCH({"multirec ended","warning"},A:A)))),12,8),SEQUENCE(A2))
Finally it's worth noting I'm looking to make one array formula with regards to my output, in my many google searches I found various half baked solutions but nothing specially referencing what I need.
Thank you in advance.
Bookmarks