You do not need FILTER() twice. You can choose columns from INDEX(). Try-=INDEX(SORT(FILTER(B5:E125,C5:C125>=LARGE(C5:C125,10)),4,-1),SEQUENCE(10),{1,2,4}) Answer from harun24hr on techcommunity.microsoft.com
ExcelFind
excelfind.com › tutorials › top-10-basic-excel-functions-and-formulas
Top 10 Basic Excel Functions and Formulas - ExcelFind.com
February 13, 2024 - Syntax: IF (logical_test, [value_if_true], [value_if_false]) The Excel MIN function returns the smallest numeric value in a range of values. Accordingly, the Excel MAX function returns the biggest numeric value in a range of values.
ClickUp
clickup.com › home › microsoft excel › basic 50 ms excel formulas list everyone should know
50 Basic MS Excel Formulas List that Everyone Should Know
June 28, 2025 - Top 50 Excel Formulas for Different Use Cases · Mathematical formulas · Text formulas · Logical formulas · Lookup functions and reference formulas · Statistical formulas · Date and time formulas · Financial formulas · Specialized formulas · How to Use Formulas in Microsoft Excel ·
How can I get top 10 from a table and sorted from highest to lowest.
Hi,I am trying to get top 10 from a table and sorted from highest to lowest.I have written a... More on techcommunity.microsoft.com
5
0
July 27, 2022Return Top N Values using Index Function
Not sure about that technique, but would the LARGE function meet your need? =LARGE(A1:B10,{1,2,3,4,5}) More on reddit.com
4
2
August 26, 2022function - Top 10 values in excel - Stack Overflow
enter image description hereenter image description here According to given data table, I want to find out the top 10 students on the basis of marks (by using excel query) but I think Max function... More on stackoverflow.com
How to Return Top 3 Values and Their Corresponding Cell
I'm currently using the LARGE function to return the top 3 largest values out of the list, but I also want to pull the division associated with the value. I used a vlookup to look for the value in column B and return its corresponding division, but I run into an issue if multiple divisions have the same total sales. If the top 3 divisions all have the same value, say 25, how can I get Excel ... More on learn.microsoft.com
5
10
Videos
05:05
Create a Dynamic Top N (5,10) Report Using Excel 365 Functions ...
How to Create a Dynamic Top 10 List in Excel
16:32
Top 5 Most Popular Functions In Microsoft Excel - YouTube
04:56
Find the Top 10 Values with One Excel Formula - YouTube
Find Top 5 Values and Names in Excel
06:30
Why Excel Pros Love the TAKE Function (and You Will Too) - YouTube
Quora
quora.com › What-s-the-most-useful-Excel-function-for-you
What’s the most useful Excel function for you? - Quora
Answer (1 of 4): For me, it's INDEX and MATCH. Looking up data from multiple tables in separate sheets can also be done using VLOOKUP and HLOOKUP formula. But, you have to change the column index number (or row index number for HLOOKUP) if you add more column in between the lookup column and the...
Facebook
facebook.com › groups › 1298155427292066 › posts › 1538547419919531
What is your top 5 most used Excel function?
We cannot provide a description for this page right now
W3Schools
w3schools.com › sql › sql_top.asp
SQL SELECT TOP, LIMIT and FETCH FIRST
String Functions: Asc Chr Concat ... SQL Bootcamp SQL Certificate SQL Training ... The SELECT TOP clause is used to limit the number of records to return....
Ablebits
ablebits.com › ablebits blog › excel › find & replace › excel formula to find top 3, 5, 10 values in column or row
Excel formula to find top 3, 5, 10 values in column or row
March 13, 2023 - To get the highest N values in a list, use the LARGE and ROWS functions together in this way: ... For example, to find top N values in B2:B12, you enter the below formula in the topmost cell where you want the results to appear (D2), and then ...
Reddit
reddit.com › r/excel › return top n values using index function
r/excel on Reddit: Return Top N Values using Index Function
August 26, 2022 -
Hi all, sometime back I had seen a YT video that had a neat solution to returning top N rows using the Index function, however, I am not able to find it again. I don't know if I remember it wrong or if that it is actually possible but it's eating my brain up so I thought I'd ask it here.
So the problem is this. Let's say I have data in A1:B10 and I want to return the top 5 values using the Index function.
I can use this formula - =INDEX(A12#,{1;2;3;4;5},0)
But is there a way so I can reference in the formula 1 to 5 directly instead of using semi-colons?
Edit: I am not looking to get top 5 highest values or lowest values. I am just looking to get the top 5 rows in an array. The goals is to for example, wrap it around a filter function that outputs an array to only display Top N results.
Secondly, the solution I remember seeing had an operator that replaced {1;2;3;4;5} in the formula with something shorter and dynamic, so that is specifically what I was aiming for. It is not a problem I am looking to solve currently, just curious as it was something that I hadn't seen before.
Top answer 1 of 3
1
Not sure about that technique, but would the LARGE function meet your need? =LARGE(A1:B10,{1,2,3,4,5})
2 of 3
1
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: Fewer Letters | More Letters | Last usage | Returns the column number of a reference | Last usage | Uses an index to choose a value from a reference or array | Last usage | Returns the k-th largest value in a data set | Last usage | Looks up values in a reference or array | Last usage | Returns the rank of a number in a list of numbers | Last usage | Returns the row number of a reference | Last usage | Office 365+: Generates a list of sequential numbers in an array, such as 1, 2, 3, 4 Beep-boop, I am a helper bot. Please do not verify me as a solution. 7 acronyms in this thread; the most compressed thread commented on today has acronyms. [Thread #17649 for this sub, first seen 26th Aug 2022, 12:31] [FAQ] [Full list] ^[Contact] [Source code]
Exceljet
exceljet.net › 101 excel functions you should know
101 Excel Functions you should know | Exceljet
September 27, 2024 - Excel contains over 500 functions, with more functions added every year. That is a huge number, so where should you start? This guide provides a walkthrough of over 100 important functions in Excel with many examples and links. Click function names for details and more examples.
Microsoft Support
support.microsoft.com › en-us › office › excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb
Excel functions (by category) - Microsoft Support
Lists all Excel functions by their category, such as Logical functions or Text functions.
Excel Off The Grid
exceloffthegrid.com › creating-a-top-10-using-formulas
How to calculate Top 10 with formulas in Excel
January 21, 2026 - Look at the Top 10 – DA with criteria tab in the example file. ... The only difference to the previous example is that we are using the FILTER function to include the matching items, before it is fed into the SORT function. ... It returns cells A2 to C27, but only where the corresponding values from B2 to B27 equal the selected city in cell J4. Find out more about the FILTER function in this article: FILTER function in Excel...
GeeksforGeeks
geeksforgeeks.org › excel › how-to-find-top-or-bottom-n-values-in-excel
How to find Top or Bottom N values in Excel? - GeeksforGeeks
June 24, 2024 - Excel provides powerful functions to find the top or bottom N values in a dataset, making data analysis much easier. The functions used to find the Nth largest and Nth smallest numbers are =LARGE(array, k) and =SMALL(array, k), respectively.
Exceljet
exceljet.net › filter on top n values
FILTER on top n values - Excel formula | Exceljet
May 14, 2024 - In a nutshell, this formula uses the LARGE function to find the nth largest value in a set of data. Once we have that value, we plug it into a standard INDEX and MATCH formula to retrieve the associated name. In other words, we use the nth largest value like a "key" to retrieve associated... The Excel FILTER function is used to extract matching values from data based on one or more conditions.
Top answer 1 of 2
2
You can use Large with Match and Index to get the list:-
See the image of my example. I have used dummy values.
Step1 :- Use this formula (I have used in D column 'Top 10')
=INDEX($A$2:$B$13,MATCH(LARGE($B$2:$B$13,ROW(1:1)),$B$2:$B$13,0),1)
Step2:- Then drag this formula down for 10 rows. You will get the top 10.
Let me know if you have any questions
2 of 2
-1
Try the rank functions.The original RANK has been deprecated. You can use RANK.EQ instead.
The syntax is
=RANK.EQ(value, entireRangeOfValues).
e.g. =RANK.EQ(J2,$J$2:$J$8015,0)
The last parameter allows you to specify sort order.
Depending on your needs you can also look at RANK.AVG These differ in how they rank duplicate values.
Top answer 1 of 4
5
Hi Grill
Try the following approach and formulas
Rank column =RANK.EQ(C2,$C$2:$C$26,0)+COUNTIF($C$2:C2,C2)-1
Total Sales =VLOOKUP($F2,$A$1:$C$26,3,FALSE)
Division =VLOOKUP($F2,$A$1:$C$26,2,FALSE)
I hope this helps you and gives a solution to your problem
Do let me know if you need more help
Regards
Jeovany
2 of 4
1
Hi,
In cell E2, enter this formula
=FILTER(A2:B8,RANK(B2:B8,B2:B8,0)<=3)
Hope this helps.
Microsoft Support
support.microsoft.com › en-us › office › large-function-3af0af19-1190-42bb-bb8b-01672ec00a64
LARGE function - Microsoft Support
Returns the k-th largest value in a data set. You can use this function to select a value based on its relative standing. For example, you can use LARGE to return the highest, runner-up, or third-place score. Array and K are required. If array is empty or k ≤ 0 or if k is greater than the ...
W3Schools
w3schools.com › excel › excel_functions.php
Excel Functions
Highlight Cell Rules HCR - Greater Than HCR - Less Than HCR - Between HCR - Equal To HCR - Text That Contains HCR - Date Occurring HCR - Unique Values Excel Top Bottom Rules
Bizinfograph
bizinfograph.com › home › top 10 values in excel › how to find top 10 values in excel with formulas?
How to Find Top 10 Values in Excel with Formulas?
January 17, 2024 - Step 2: Hit the ENTER key and this formula will return you the top 10 values based on a criteria. you choose. The FILTER function here returns cells A2 to D21, but only where the corresponding values from B2 to B21 equal the selected class in cell K2. 2.2 Using FILTER Function with CHOOSEROWS, CHOOSECOLS · Step 1: Place the following formula into H2 and hit ENTER key. This works in Excel 365 only.
TechTarget
techtarget.com › searcherp › answer › Finding-the-top-three-values-using-the-Excel-LARGE-function
How to use the Excel LARGE function, with examples | TechTarget
September 9, 2025 - While LARGE and SMALL aren't the most popular functions, they're useful for finding the top three, top five, top 10 or bottom three values from a range. Eric St-Jean is an independent consultant with a particular focus on HR technology, project management and Microsoft Excel training and automation.
XelPlus
xelplus.com › home › tutorials › how to get top values in excel with the filter function
How to Get Top Values in Excel with the FILTER Function - Xelplus - Leila Gharani
May 23, 2024 - Learn how to use the FILTER function in Excel to find the top values in your data. Simplify your work with step-by-step instructions.