Formula to Count how many times Yes appears in a cell

[squeakums]

I'd like a formula to find if a cell has Yes in it and then pull the data if the cell does, otherwise leave blank.

 

[Joe4]

Try this formula:

=(LEN(F2)-LEN(SUBSTITUTE(F2,"Yes","")))/3

 

[squeakums]

Try this formula:

=(LEN(F2)-LEN(SUBSTITUTE(F2,"Yes","")))/3

Yes, thank you that counts the items, now how would I write in a formula that brings in data that says yes or brings in all data if there is a yes. The data name would be to the left of yes for each yes.

 

[Fluff]

Surely that's the same question as you asked here Formula that if the cell contains any "Yes" pull the word to the left of it (it may have multiple yes')

 

[Joe4]

Yes, thank you that counts the items, now how would I write in a formula that brings in data that says yes or brings in all data if there is a yes. The data name would be to the left of yes for each yes.

Why are you asking that question again?
It was already solved for you yesterday.