Select Page

Want to RANK higher in your Excel knowledge? Watch Excel Video 196. Excel uses RANK functions to show how items rank in a list. You can rank either descending (highest to lowest) or ascending (lowest to highest) and descending is the default for both functions.
Watch Excel Video 196 to see the two versions of RANK, RANK.EQ and RANK.AVG. Both functions do exactly the same thing and have the same syntax. The only difference between RANK.EQ and RANK.AVG is the way they handle ties. RANK.EQ assigns the top rank among the ties to each of the ties. RANK.AVG takes the average rank among the ties and assigns that rank to each of the ties.
Excel Video 196 completes what I want to cover about formulas for now. Stay tuned. Next time we’ll start on the rest of the Formulas tab, Formula Auditing and Calculation.