The Excel RANK. AVG function returns the rank of a number against a list of other numeric values. When values contain duplicates, the RANK. AVG function will assign an average rank to each set of duplicates.
« Back to Glossary Index
The Excel RANK. AVG function returns the rank of a number against a list of other numeric values. When values contain duplicates, the RANK. AVG function will assign an average rank to each set of duplicates.