Select the Top 5 Values with TAKE function Learn how to find the top 5 values or the last 5 values from a list in Excel using the TAKE function and SORT function.