Solved Show results in Column if other columns have Yes or No (1 Viewer)

[Number11]

Hello,

So i have an excel spreadsheet that contains 3 columns the answered will be
C E F
Yes No No
Yes No No
No No Yes
No Yes No

i need to create a new column that will say if Yes was within one or more of the three so i can then filer the data for all Yes
any ideas

 

[Isaac]

You can try an OR statement wrapped in an (outer) IF statement

 

[Gasman]

Or a FIND perhaps?
On my phone at present, so cannot test
What about Countif ?

 

[Isaac]

True, you could test if IsError(Find(ConcatenationofTheThree))

 

[Number11]

True, you could test if IsError(Find(ConcatenationofTheThree))

Ok thanks any examples

 

[Isaac]

OR function (microsoft.com)

 

[Gasman]

Ok thanks any examples

Google countif()

 

[oleronesoftwares]

=IF((OR(C=yes, E=yes,F=yes)), "Yes", "")

 

[Gasman]

=IF((OR(C=yes, E=yes,F=yes)), "Yes", "")

Wouldn't the Yes strings need to be within quotes?

 

[oleronesoftwares]

Yes they have to be in quotes, apologies for the incomplete solution sent earlier.

 

[Number11]

Yes they have to be in quotes, apologies for the incomplete solution sent earlier.

thank you so much worked perfectly

 

[Gasman]

If it just those three columns then the OR would be fine, but if you expanded the range that would become a real pain.?
Then I would use the CountIf option?