title: How do I return the most frequently occurring text value in range of text values in a Google Docs spreadsheet?
body: <p>I have a range <code>B2:B7</code> which contains text values that stand for something, but what I want is to have a cell display the text value that comes up the most in that range. </p>
  
  <p>So for example if my range contained the text values {"red", "green", "green", "blue", "green", "blue"}, the average value displayed in the cell would be "green". </p>
  
  <p>How do I do this? </p>