Forum Discussion

Jason2235's avatar
Jason2235
Copper Contributor
Jan 18, 2023
Solved

highlighting a row based on multiple piece of text (eg in a calendar of people's availability)

Hi All, An absolute laymen here - I've been trialling and erring trying to sort out a home made calendar of people's availability and it doesn't do what I would like - I have figured out some elem...
excel
Formulas and Functions
  • Patrick2788's avatar
    Patrick2788
    Jan 20, 2023
    =AND(MATCH("*xx*",$C2:$F2,0),MATCH("*family holiday*",$G2,0))
Jason2235's avatar
Jason2235
Copper Contributor
Jan 20, 2023

Patrick2788 

 

terribly sorry about that - I missed that bit in my original message.

 

I've tried: 

=AND(MATCH("*xx*",$C2:$F2,0),$G2="*family holiday*")

 

and it seems to break the formula. If I remove those two wildcards then the formula works again but isn't a partial match which is ideally what I am after. 

 

Patrick2788's avatar
Patrick2788
Silver Contributor
Jan 20, 2023
=AND(MATCH("*xx*",$C2:$F2,0),MATCH("*family holiday*",$G2,0))
  • Jason2235's avatar
    Jason2235
    Copper Contributor
    Jan 20, 2023

    Patrick2788

    you sir should be knighted!!! Thank you, I was messing around yesterday and got quite close to what you have posted above....but not close enough.

    Thank you *scrapes and bows*

Resources