Find the top 5 values in excel - dynamic array formulas & original formulas

In this video I show you two different methods for finding the largest and the smallest values in a range in excel.

Method 1:
=SORT(FILTER(A3:D29,RANK.AVG(D3:D29,D3:D29,0)⋖=5),4,-1)

Method 2:
=LARGE($D$3:$D$29,ROW()-4)
=SMALL($D$3:$D$29,L14)
=INDEX(A$3:A$29,MATCH($P5,$D$3:$D$29,0))
--------------------------------------------------------------------------------
#exceltutorial #excelformulas #exceldynamicarrays

Microsoft Office 365, 2016, Office Insider, Version 1902

The FILTER and SORT formulas are currently only available in the Office Insider version of Office 365 or in Google Sheets.

These data are related to my PhD research
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: