Ranking Data in Excel Without Sorting - K2 Enterprises The RANK function in Excel allows you to use a formula to determine the relative position, or order, of one value in a range of data compared to the other values ...