title: How to find a specific text from a column that a set of comma separated values in Excel?
body: <p>I have a column like this</p>
  
  <p><a href="https://i.stack.imgur.com/lUPod.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lUPod.png" alt="enter image description here"></a>
  <br>
  Now I know the set of values. Like someone was asked about 'Sports' and he/she had the below choices:<br><br>
  Cricket <br>
  Tennis <br>
  Football <br>
  Others <br></p>
  
  <p>Now the values that you see in any cell of the column apart from 'Cricket', 'Tennis' or 'Football' are entered as 'Others'</p>
  
  <p>So I want the output in this manner that will only fetch what has been put as 'Others' and where it was not chosen it will be '0' (zero)
  <a href="https://i.stack.imgur.com/mriPn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mriPn.png" alt="enter image description here"></a></p>
  
  <p>But if you see I was taking about 'Others' as an example. For this example, there is no such letter as 'Others', instead of there are 'I dont like any sports' or 'Playing sports was good at home' etc which can be anything followed by. So I want to show anything that doesn't match with 'Cricket', 'Football' or 'Tennis'</p>
  
  <p>I'm a very novice at Excel and kind of doing this first time. Can anyone help what formula should I write at the starting of B column?</p>