title: Count occurrences of words from multiple columns
body: <p>I have a spreadsheet like this, where the values A-E are the same options coming from a form:</p>
  
  <pre><code>+------+------+------+
  | Opt1 | Opt2 | Opt3 |
  +------+------+------+
  |   A  |   A  |   B  |
  |   B  |   C  |   A  |
  |   C  |   C  |   B  |
  |   A  |   E  |   C  |
  |   D  |   B  |   E  |
  |   B  |   E  |   D  |
  +------+------+------+
  </code></pre>
  
  <p>I want to make a ranking, showing the most chosen options for each option. I already have this, where Rank is the ranking of the option and number is the count of the option:</p>
  
  <pre><code>+------+------+------+
  | Rank | Opt1 | Numb |
  +------+------+------+
  |   1  |   A  |   2  |
  |   1  |   B  |   2  |
  |   3  |   C  |   1  |
  |   3  |   D  |   1  |
  +------+------+------+ (I have 3 of these, one for each option)
  </code></pre>
  
  <p>I want to do now a summary of the 3 options, making the same ranking but joining the options. It would be something like:</p>
  
  <pre><code>+------+------+------+
  | Rank |Opt123| Numb |
  +------+------+------+
  |   1  |   B  |   5  |
  |   2  |   A  |   4  |
  |   2  |   C  |   4  |
  |   4  |   E  |   3  |
  |   5  |   D  |   2  |
  +------+------+------+
  </code></pre>
  
  <p>The easiest way to do this would be getting the data from the three ranking tables or from the original three data columns?</p>
  
  <p>And how would I do this?</p>
  
  <p>I already have the formula to get the names of the options, the count and ranking, but I don't know how to make them work with multiple columns.</p>
  
  <p>What I have (the F column is one of the data columns):</p>
  
  <p>Column B on another sheet:</p>
  
  <pre><code>=SORT(UNIQUE(FILTER('Form Responses'!F2:F;NOT(ISBLANK('Form Responses'!F2:F)))); RANK(COUNTIF('Form Responses'!F2:F; UNIQUE(FILTER('Form Responses'!F2:F;NOT(ISBLANK('Form Responses'!F2:F))))); COUNTIF('Form Responses'!F2:F; UNIQUE(FILTER('Form Responses'!F2:F;NOT(ISBLANK('Form Responses'!F2:F))))); TRUE); FALSE)
  </code></pre>
  
  <p>Column C:</p>
  
  <pre><code>=ArrayFormula(COUNTIF('Form Responses'!F2:F; FILTER(B2:B;NOT(ISBLANK(B2:B)))))
  </code></pre>
  
  <p>Column A:</p>
  
  <pre><code>=ARRAYFORMULA(SORT(RANK(FILTER(C2:C;NOT(ISBLANK(C2:C))); FILTER(C2:C;NOT(ISBLANK(C2:C))))))
  </code></pre>