How do I find the Top 3 highest values in Excel? - Excel Tips and Tricks

Discover how to find the top 4 highest value and lowest value in Excel.

Excel is a powerful tool for data analysis, and finding the top values in a dataset is a common task. One way to find the top 3 values in Excel is by using the sort filter and the LARGE function. First, select the range of cells containing the data you want to analyze. Next, click on the "Data" tab and select "Sort Largest to Smallest" to sort the data in descending order. Then, use the LARGE function to find the top 3 values. The syntax for the LARGE function is "=LARGE(array, k)", where "array" is the range of cells containing the data and "k" is the ranking of the value you want to find. To find the largest value, use "=LARGE(array,1)", and for the second largest, use "=LARGE(array,2)", and so on. Repeat the formula for the third largest value, and you'll have your top 3 values.

Top 3 Most Popular Shoes Sold
=SORT(FILTER(A20:E88,E20:E88>=LARGE(E20:E88,3)),5,-1)

Top 3 Lease Popular Shoes
=SORT(FILTER(A20:E88,E20:E88=LARGE(D20:D88,3)),4,-1)

How do I find the Top 3 highest values in Excel?,
excel top 3 values and names,how to find lowest 3 values in excel,excel top 5 values and names with criteria,find the top 10 values in an excel range without sorting,how to find top 5 values in excel
excel top 10 text values,how to calculate best 2 out of 3 in excel,
How do I find the Top 3 highest values in Excel?,How do I select Top 5 values in Excel?,How do you lookup three values in Excel?,