title: Using Excel to display the number of occurrences within a date range
body: <p>I've got a list of transaction dates and the user id of the person who made the transaction on that date (just 1 Tx/day allowed).  For example:</p>
  
  <p><img src="https://farm5.static.flickr.com/4045/4282685403_9d4412878c_o.png"></p>
  
  <p>I'd like to create a matrix which shows, as of each date, the number of users who have made 1 transaction, 2-10 transactions, 10-20 transactions, etc.  For example (note, the below data doesn't correspond to the transaction data above):</p>
  
  <p><img src="https://farm5.static.flickr.com/4007/4282685425_aa3f85b625_o.png"></p>
  
  <p>Is a pivot table my best mechanism here?  If so (or not) how would I approach this?</p>