Excel Formula To Show Top X Percentage Of An Array

microsoft-excel worksheet-function array

The solution is pretty straightforward. It requires the SMALL() function:

Worksheet Screenshot

Enter the following formula in D2:

=SMALL(B2:B11,ROWS(B2:B11)*0.8)

Note that the LARGE() function could also be used but it is not as elegant:

=LARGE(B2:B11,ROWS(B2:B11)*(1-0.8)+1)

Related

Script to create folder with same name as start of filename and move files with same start name into folder
"The attempted operation is not supported for the referenced object type" when installing Ubuntu WSL on Windows 10
How to persist bash history?
DD-WRT with native IPv6
How to prove that $\lim_{h\to 0} \, \frac{e^h-1}{h}$
Is the set of all strings with countably infinite length bijective to $[0,1]$?
Proof that Radius of Convergence Extend to Nearest Singularity
When does product of derivatives equals derivative of products?
Prove Taylor series converges to $f$.
Inequality involving sides of a triangle
Is answer of limit an exact value?
Distributing identical objects to identical boxes