Calculate Percentile and Conditional Ranking in Excel Using SUMPRODUCT

The Excel functions for performing ranking and establishing percentiles are poorly described and confusing to use on the best of days. The PERCENTILE function doesn’t give the percent ranking of the item, but the instead the value at a given percentile (w

exceltactics.com