Formula that if the cell contains any "Yes" pull the word to the left of it (it may have multiple yes')

[squeakums]

For Cell F2 if it contain the word Yes, pull the word to the left of yes. Is this something that can be written. It may have multiple yes fields.

 

[Joe4]

It is not quite clear to me exactly what you are looking for and where exactly you want it to go (and I suspect others may have the same questions too, since no one has replied yet).
Can you show us an example of your data and expected output?

 

[squeakums]

It is not quite clear to me exactly what you are looking for and where exactly you want it to go (and I suspect others may have the same questions too, since no one has replied yet).
Can you show us an example of your data and expected output?

Something like this, the formula would be in the if yes field.

Questions Answered	If Yes
Cats Yes, Dogs No, Parrot Yes, Fish Yes, Lizards No	Cat, Parrots, Fish

 

[Joe4]

When you said "multiple yes" entries were possible, I thought you meant in individual/different cells, not multiple entries like that in the same cell.
That makes things much harder.

I would have to use VBA on something like this. There are some formula wizards on this site who can probably do it without VBA, but it is a little beyond my skill level.

 

[Fluff]

How about

Fluff.xlsm
	A	B
1
2	Cats Yes, Dogs No, Parrot Yes, Fish Yes, Lizards No	Cats, Parrot, Fish
Sheet4

Cell Formulas
Range	Formula
B2	B2	=LET(a,TEXTSPLIT(A2," ",", "),TEXTJOIN(", ",,FILTER(INDEX(a,,1),INDEX(a,,2)="yes")))

 

[squeakums]

How about

Fluff.xlsm
	A	B
1
2	Cats Yes, Dogs No, Parrot Yes, Fish Yes, Lizards No	Cats, Parrot, Fish
Sheet4

Cell Formulas
Range	Formula
B2	B2	=LET(a,TEXTSPLIT(A2," ",", "),TEXTJOIN(", ",,FILTER(INDEX(a,,1),INDEX(a,,2)="yes")))

Fluff sorry I didn't realize you replied on this. I appreciate it. It doesn't seem to work with my layout it has a calc error. Here is an example of my layout.

 

[Fluff]

That's because the data in the image, is completely different from the data you posted in post#3
Please post some accurate data.

 

[squeakums]

That's because the data in the image, is completely different from the data you posted in post#3
Please post some accurate data.

My apologies, this is the type of data I'm working with.

 

[Fluff]

Can you post a few samples of that data, preferably using the XL2BB add-in.

 

[squeakums]

Can you post a few samples of that data, preferably using the XL2BB add-in.

My work PC wouldn't allow me to install that unfortunately, I will need to recreate this at home and send it. I wish they allowed us to post excel docs still.