How do you calculate the Quintile for groups of rows in Excel?
<p>I found a partial answer to this question under <a href="https://stackoverflow.com/questions/28287587/how-do-you-calculate-the-quintile-for-every-row-in-excel">How do you calculate the Quintile for every row in Excel?</a>. I would like to derive the same quintile data for each row but I need the quintiles to be based on groups that are determined by a value in another column. </p>