title: How to quintile by date group using Percentile in excel
body: <p>Im just wondering if its possible to quintile my data by group in Excel, using the percentile function.</p>
  
  <p>I can quintile my entire data by doing <code>=MATCH(C2|PERCENTILE(C$2:C$20|{5,4,3,2,1}/5)|-1)</code> but I want to group it up by date.</p>
  
  <p>e.g of data</p>
  
  <pre><code>Date    Team_Id Score
  04/02/2019  1   50
  04/02/2019  2   58
  04/02/2019  3   75
  04/02/2019  4   34
  04/02/2019  5   52
  04/02/2019  6   81
  05/02/2019  1   87
  05/02/2019  2   75
  05/02/2019  3   24
  05/02/2019  4   75
  05/02/2019  5   11
  05/02/2019  6   84
  06/02/2019  1   45
  06/02/2019  2   67
  06/02/2019  3   56
  06/02/2019  4   55
  06/02/2019  5   61
  06/02/2019  6   15
  06/02/2019  7   88
  </code></pre>
  
  <p>So basically I want it to be quintiled by Score for each date group, resulting value for each row in Excel should be 1, 2, 3, 4, or 5. Ive been messing around with IF but just dont know where to place it.</p>