=transpose(sortby(b1:e1, b8:e8, -1)) Answer from HandbagHawker on reddit.com
DataCamp
datacamp.com › tutorial › rank-formula-in-excel
Rank Formula in Excel: A Comprehensive Guide With Examples | DataCamp
July 16, 2024 - If you want to assess your sales team's performance, you can rank their monthly sales figures using Excel's RANK() function. Here, we have a dataset with monthly sales figures for each salesperson. We'll use the RANK() function to rank them based on who brought in the most sales (highest to lowest).
MrExcel
mrexcel.com › forums › question forums › excel questions
Ranking of numbers from lowest to highest | MrExcel Message Board
August 25, 2004 - Hi, sorry, that should be =RANK(cell ref,range ref,0) where cell ref is the cell referenced range ref is the range of the cells and the rest is as you know. ... Assuming that your numbers are in Column A...
How to Rank from Highest Performer to Lowest Performer
/u/Redversion - Your post was submitted successfully. Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread. Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. Include your Excel version and all other relevant information Failing to follow these steps may result in your post being removed without warning. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns. More on reddit.com
10
3
July 5, 2024Taking the 5 highest values and 5 lowest values from a column
Something like below. =FILTER(Data,(ValueColumn>=LARGE(ValueColumn,5))+(ValueColumn<=SMALL(ValueColumn,5))) Edit: Oh if you need data sorted, you can nest it in SORT(Formula,2,1). Alternately you can split into two Filter() formula to return 5 highest and 5 lowest separately. More on reddit.com
7
7
March 1, 2024How 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, 2022Formula to return a name based on highest and lowest results in a specific class, yields only highest result
Since you have possible ties, and thus multiple results, I would suggest using FILTER rather than a lookup formula. So, could do =FILTER(Table, (Table1[Teacher]="Smith")*(Table1[Score]=MAXIFS(Table1[Score], Table1[Teacher], "Smith"))) Note that you'll need to change table name and column names to match your setup. Change MAXIFS to MINIFS to get the lowest score(s). This one formula will return all rows AND columns from the table that match your criteria. More on reddit.com
4
1
February 11, 2025Videos
Microsoft Support
support.microsoft.com › en-us › office › rank-function-6a2fc49d-1831-4a03-9d8c-c279cf99f723
RANK function - Microsoft Support
In the following example, RANK(A2,A1:A5,1) equals 3. The correction factor is (5 + 1 – 2 – 3)/2 = 0.5 and the revised rank that takes ties into account is 3 + 0.5 = 3.5. If number occurs only once in ref, the correction factor will be 0, since RANK would not have to be adjusted for a tie. Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet.
Reddit
reddit.com › r/excel › how to rank from highest performer to lowest performer
r/excel on Reddit: How to Rank from Highest Performer to Lowest Performer
July 5, 2024 -
In this example, I have four stores that are each selling various categories of items and they each have a total in their respective column. On the right-hand side, I've manually ranked the highest performer to the lowest, based on the total in each store's column.
I typically will copy/paste over the cell's data on a daily basis (so the data changes frequently), but I'm trying to figure out how to have the "Rank" column update automatically, without having to manually change it each time. Essentially, the only rows I care about are Row 1 and Row 8.
Any help is much appreciated!
Exceljet
exceljet.net › rank function
Excel RANK function | Exceljet
June 8, 2025 - Otherwise, Excel will display the "There's a problem with this formula" error dialog. You can use the RANK function to rank numeric values. RANK has two modes of operation: ranking values so that the largest value is ranked #1 (order = 0), and ...
Excel Forum
excelforum.com › excel-general › 882736-need-a-formula-to-rank-highest-to-lowest-values-numerically-new-post.html
Need a formula to rank highest to lowest values numerically [SOLVED]
September 12, 2012 - the function rank is used in ranking =RANK(B3,$B$3:$B$14,0) or =RANK(B3,$B$3:$B$14,1) note the bold parts to see the difference.
Quora
quora.com › How-do-you-find-the-highest-and-lowest-value-from-a-list-of-numbers-using-Microsoft-Excel
How to find the highest and lowest value from a list of numbers using Microsoft Excel - Quora
In the following example, I have used the FILTER function in Excel to remove the largest and smallest values from a list of 10 numbers. =FILTER(B2:B11,(B2:B11>LARGE(B2:B11,10))*(B2:B11<SMALL(B2:B11,10))) ... Use rank function if you are using ...
Reddit
reddit.com › r/excel › taking the 5 highest values and 5 lowest values from a column
r/excel on Reddit: Taking the 5 highest values and 5 lowest values from a column
March 1, 2024 -
Looking for a way to pull values from a data table into another sheet. I would like to pull the 5 highest values and the 5 lowest values. not having much luck.
Would also like to pull the corresponding data on the same row if possible.
Top answer 1 of 5
7
Something like below. =FILTER(Data,(ValueColumn>=LARGE(ValueColumn,5))+(ValueColumn<=SMALL(ValueColumn,5))) Edit: Oh if you need data sorted, you can nest it in SORT(Formula,2,1). Alternately you can split into two Filter() formula to return 5 highest and 5 lowest separately.
2 of 5
3
You can use "Large" and "Small" formula. In my example, I use D1 as reference to make it easier to drag down but instead of D1 in the formula, you can just use 1, 2, 3 as the rank you need. Example (=LARGE($A$1:$A$15,1) )
Microsoft Support
support.microsoft.com › en-us › office › rank-eq-function-284858ce-8ef6-450e-b662-26245be04a40
RANK.EQ function - Microsoft Support
Ref Required. An array of, or a reference to, a list of numbers. Non-numeric values in Ref are ignored. Order Optional. A number specifying how to rank number. If Order is 0 (zero) or omitted, Excel ranks Number as if Ref were a list sorted in descending order.
Simplilearn
simplilearn.com › home › resources › data science & business analytics › excel tutorial for beginners › rank function in excel
RANK Formula in Excel: A Comprehensive Guide
August 24, 2025 - In Excel, use the RANK function by entering =RANK(number, ref, [order]) where number is the value to rank, ref is the range of data
Address 5851 Legacy Circle, 6th Floor, Plano, TX 75024 United States
Statology
statology.org › home › how to rank values with ties in excel (3 methods)
How to Rank Values with Ties in Excel (3 Methods)
June 26, 2023 - This method assigned a rank of 1 to the first highest value that occurred and a 2 to the highest value that occurred next. Since Doug appeared first in the dataset he received a rank of 1 and Eric then received a rank of 2. When ranking values in your own dataset, feel free to choose whichever method you prefer best. The following tutorials explain how to perform other common tasks in Excel:
Ablebits
ablebits.com › ablebits blog › excel › excel formulas › excel rank function and other ways to calculate rank
Excel RANK function and other ways to calculate rank
March 17, 2023 - Another way to rank numbers in Excel uniquely is by adding up two COUNTIF functions: The first function determines how many values are greater than or less than the number to be ranked, depending on whether you are ranking descending or ascending, respectively. The second function (with the "expanding range" $B$2:B2 as in the above example) gets the number of values equal to the number. For example, to rank numbers uniquely from highest to lowest, you'd use this formula:
Corporate Finance Institute
corporatefinanceinstitute.com › home › resources › rank function
RANK Function - Formula, Examples, How to Use Rank in Excel
July 18, 2019 - The RANK Function is categorized as an Excel Statistical function. The function returns the statistical rank of a given value within a supplied array of values.
Reddit
reddit.com › r/excel › formula to return a name based on highest and lowest results in a specific class, yields only highest result
r/excel on Reddit: Formula to return a name based on highest and lowest results in a specific class, yields only highest result
February 11, 2025 -
What the text says. I have a table and data set on different sheets to return results based on a listed name. I used MAXIFS and MINIFS to return highest and lowest score, and xlookup to return the name.
EG I want to know who got the highest and lowest score in Richard’s class Students - Scores: Williams - 100 Grant - 90 Cruise - 80 Shatner - 100 Alba - 79
This will yield Williams as the highest and Alba as the lowest
My issue is when multiple people have the same high or low score in a class
EG Smith Students - Scores: Goggins - 100 Plaza - 100 Robbie - 100
This will tell me that Williams has the highest and lowest score in the class, despite not being a student in Smiths class. What do I need to do to yield the results the way I want?
I don’t have a problem with only 1 person being listed for a high score but if that needs to change in order to list it properly, I can work around it. Thanks!
Top answer 1 of 4
2
Since you have possible ties, and thus multiple results, I would suggest using FILTER rather than a lookup formula. So, could do =FILTER(Table, (Table1[Teacher]="Smith")*(Table1[Score]=MAXIFS(Table1[Score], Table1[Teacher], "Smith"))) Note that you'll need to change table name and column names to match your setup. Change MAXIFS to MINIFS to get the lowest score(s). This one formula will return all rows AND columns from the table that match your criteria.
2 of 4
1
u/Homelessbozo - Your post was submitted successfully. Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread. Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. Include your Excel version and all other relevant information Failing to follow these steps may result in your post being removed without warning. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
MrExcel
mrexcel.com › forums › question forums › excel questions
Rank table highest positive to lowest positive first, then lowest negative to highest negative. | MrExcel Message Board
December 21, 2024 - I suppose how I presented the question was confusing. Below is a better example rank value 2) 15 4) -40 6) -2 1) 20 5) -12 3) 10 ... Ah, I see, my bad then. The question remains how to handle ties - see how this will work: ... Does this do what you want? (BTW, can your data include zero values?
Reddit
reddit.com › r/excel › what function to use to rank/choose among options?
r/excel on Reddit: What function to use to RANK/CHOOSE among options?
September 28, 2024 -
Hello!
Hoping you all can help me impress my team. Every week during our team meeting we create this list of issues to discuss. Then my manager goes around and asks all 5 of us for the numbers of our top 3 — she writes them down and comes up with an order.
If the items are related to a high-priority product they get pushed to the top of the list, but otherwise, it’s just based on our rankings. But it can be a bit messy when all of our rankings are different, and I think there could be a better way to choose among the options.
I’d like to create a spreadsheet where the team members enter the numbers of the top three issues they’d like to discuss. The spreadsheet would then choose among those and spit out the numbers of the top three issues for the team.
The first thing I tried is a COUNT for each number, but what do in case of a tie?
I’d appreciate any direction you fine folks can offer!
Top answer 1 of 4
1
u/AstronautMaleficent4 - Your post was submitted successfully. Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread. Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. Include your Excel version and all other relevant information Failing to follow these steps may result in your post being removed without warning. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
2 of 4
1
Try this The result is a list sorted by decreasing rank. It does not take into account ties; you'll have to figure that out manually as is the case in the example above. Formula: =LET(ranks,BYROW(B2:E12,LAMBDA(x,SUM(IF(x=0,999,x)))),issues,A2:A12,array,HSTACK(issues,ranks),SORT(array,2))
MrExcel
mrexcel.com › forums › question forums › excel questions
Ranking (lowest to highest) | MrExcel Message Board
August 1, 2010 - You must log in or register to reply here. ... Rank table highest positive to lowest positive first, then lowest negative to highest negative.
YouTube
youtube.com › shorts › 4TUwoi9EV8k
How to Rank from Highest to Lowest in Excel - YouTube
In this short tutorial, I show how to easily rank values from highest to lowest using the RANK.EQ function.Stay up to date with FREE lessons by subscribing t...
Published May 21, 2023