Excel’s Ranking function allows you to quickly identify the highest and lowest values in a list, ... Ensure that your data is organized in a single column or row. Use the RANK Function.