title: How can I do the equivalent of a COUNT/GROUP BY in Excel?
body: <p>I have a table in an Excel spreadsheet. I'd like to get the equivalent of doing something like</p>
  
  <pre><code>SELECT col1, COUNT(col1), COUNT(col2)
  FROM table
  GROUP BY col1
  </code></pre>
  
  <p>in SQL. I was trying to use Pivot Tables, and I am maybe overthinking this, but I'm not used to working in Excel and couldn't figure it out.</p>
  
  <p>All help appreciated. Thank you.</p>