What is RANK.AVG function in Excel? RANK.AVG function is one of Statistical functions in Microsoft Excel that returns the rank of a number in a list of numbers: its size relative to other values in the list; if more than one value has the same rank, the average rank is returned. Syntax of RANK.AVG function RANK.AVG(number,ref,[order]) The RANK.AVG function syntax has the…