Regular Visitor
Posts: 23
Registered: ‎02-03-2016

Count of occurences within a row

I was wondering is there a function that could calculate number of occurences within one row? 

For example, i want to calculate the number of times word "red" occures within a row.


Result would look something like this:



     Color                |  Red  |  Blue


 Red, Blue, Red      |   2     |  1


  Red, Red, Red      |    3    |   0