# Learn How to Filter On Top n Values in Microsoft Excel

Written by | 0 Comments | 342 Views

In this article, you will learn how to evaluate things in Dynamic Arrays with formulas in Microsoft Excel using a single/combination(s) of functions. You will also know How to Filter On Top n Values and see the generic formula.

Learn How to Filter On Top n Values in Microsoft Excel

The main purpose of this formula is to filter a set of data to show the top n values. Here we will learn how to filter top n values in the given data range in the workbook in Microsoft Excel. That implies, with the help of a formula based on the FILTER, and LARGE function you can able to filter a set of data to show the top n values. So, with the help of this formula, you can able to filter top n values in the given data range in the workbook in Microsoft Excel.

General Formula to Filter On Top n Values

=FILTER(data,range>=LARGE(range,n))

The Explanation for the Filter On Top n Values

So we know that with the help of the given formula above you can able to show the top n values. Here we will learn how to filter top n values in the given data range in the workbook in Microsoft Excel. As we know that the FILTER function utilizes this formula to retrieve data based on a logical test constructed with the LARGE function. The LARGE function is a simple way to get the nth largest value in a range. You need to provide a range for the first argument (array), and a value for n as the second argument (k). So, with the help of this formula, you can able to filter a set of data to show the top n values. Here we will learn how to filter top n values in the given data range in the workbook in Microsoft Excel.