Excel Magic Trick 1135

Rank Values From Two Columns: RANK.AVE, RANK.EQ & RANK Functions

DESCRIPTION

See how to rank values from non-contiguous columns (columns not next to each other) using:
1) RANK.AVE function to rank Boomerang Maximum Time Aloft Scores from biggest to smallest, with tied ranks being averaged.
2) RANK.EQ function to rank Boomerang Maximum Time Aloft Scores from biggest to smallest, with tied ranks getting same rank.
3) RANK function to rank Boomerang Maximum Time Aloft Sports Scores from biggest to smallest, with tied ranks getting same rank.
4) RANK.AVE function to rank Boomerang Fast Catch Scores from smallest to biggest, with tied ranks being averaged.

WORKBOOKS




Be the first to comment

Leave a Reply