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<=SMALL(E20:E88,3)),5,1)

Top 3 Most Expensive Shoes In Store
=SORT(FILTER(A20:E88,D20:D88>=LARGE(D20:D88,3)),4,-1)


#microsoft #excel #exceltips #tips #exceltricks #tricksandtips