rank

Hi everyone! New user and novice excel user here trying to figure our a solution to a problem. I included a video instead of typing out the question here because it's kind of complicated with the concatenate functions that I'm using. The end-goal of what I'm trying to accomplish is based on a...

Hi guys, I need help in trying to get a "rank" of text. Let me explain. I have a spreadsheet where column A has repeating values, while column B shows the rank/count of these values. I have attached a screenshot of a simple example. The letter A shows up a total of 3 times, and column B is...

I am building an NBA stats workbook where I have separate sheets for each stat (points, rebounds, etc.). I am tracking this data in one sheet and I have the date of the game for that player in column A. One of the stats that I am tracking is the difference between the player's average for that...

So here's the set up. I need to rank a time in Column S in ascending order (fastest to slowest), but with consideration of the number of penalties in Column T. It seems like it should be easy, but it's a bit vexing. The ranking is no problem as long as everyone has a slightly different time...

I have a file with different rankings even though they have the same scores. It was not a rounding off issue and I tried to reapply formula but still the same outcome. this is the formula i am using =RANK(N9,$N$9:$N$73)

Hi, I've been trying to use topn to get the Nth hightest, selling item, I've tried ; EVALUATE TOPN(4,VALUES( Table1[Item]) ,[totalUnits] ) and then thought to wrap this in a MINX to get the 4th top Item,, MINX( TOPN(4,VALUES( Table1[Item]) ,[totalU] ), Table1[Item] )...

This might be very trivial but I can't for the life of me work it out. 8-12 cells affected, using default conditional formatting rules 'Format all cells based on their values' - Format style '3-Color Scale' and midpoint Percentile '50'. Maximum and minimum are left as 'Highest value' and...

Hi Everyone, I am working on a practice file with help of a video explaining every step to create a dashboard file. Everything went fine and clearly understood until I came to the Rank function to get the top rank of the products. The function worked fine but when I click on any slicer to...

I'm trying to come up with a function that ranks scores sequentially with ties receiving the same rank. I've gotten really close by using: =SUMPRODUCT((I5>=I$5:I$129)/COUNTIF(I$5:I$129,I$5:I$129)) In fact, this works perfectly when sorting smallest to largest: In a ranking of 125...

I want top 3 Unique students ranking filtered from records below along with their details and all the other roll numbers excluding the ones that are once already mentioned once in the left Only that appeared on top 3 in the last column (with Comma separation) D1125A8:I20,J11:N20Cellcontains a...

I have lost hope of me being able to work this one out, although sure easy for you all I am trying to rank each product individually by date in excel, so effectively each product in the list will have its own rank by date. For example Tomato Sauce rank 1, 2, 3, 4 etc. Black Bean CPU rank 1...

Hello guys :giggle: Hope you have a nice day! I need to rank projects in descending order based on: 1. Their scores 2. If their scores are a tie, compare their YTD scores - the higher score the better rank 3. If their YTD scores are also a tie, just randomly assign their ranks *I want the ranks...

Hello, I would like to look in a range to see if two ranks match, if they do I would like excel to output both team names into two separate cells. For example in my image I would like to get Team 1 and Team 2 as my output but separate cells. I believe I need an array formula? but I cannot...

Hi all, I have read a lot of the forums to related about rank by multiple criteria, but I still not work for me. I would like to rank by value sales (column F) based on Shop, Category and Period. I have already input the expected rank in last column, please kindly help me to solve this...

Hello, I'm trying to create a column with a rank of values based on a control column. I've posted this in StackOverflow but I feel this forum is more appropriate for the topic. My data: (A) (B) (C) Value Control Rank 100 1 8 200 1 6 200 1 7 300 0...

Hi Team, This is my first post and apologies if I am overstepping any rules here. I have gone through similar posts, but didnt find a way forward. There are similar threads, but the issue here is a bit different. The problem Statement is as follows - I need to calculate the time taken before a...

Hi everyone, I have to put an evaluation to the certain data set (ex : image below), and I'm attempting to create a summary for the cumulative sum of value by rank per group. Column A is the number of data Column B is the Group of each data Column C is the value of each data Column D is the...

Hi All, I have been working on sorting members of a club into Random Names into Groups of 4 People. I have 2 sheets that I use for this. This is sheet 1 below for the purpose of this I have used animals instead of names. Following Formulas used below: Column E Copied down to E28 First Row 5...

Hello. I have, say, used RANK in column A to rank 100 products profitability. In column B I have used the formula next to each rank number: IF(AND(A1>=1,A1<=5),"Gain","") to pick out top 5 performers i.e. 1,2,3,4,5 from the ranked list (1 being the best). I now want to also pick out the top...

Hi there, So i have a bunch of stock price returns that i am ranking relative to one another. I am then trying to assign weights based on the highest 2 and lowest 2. These should sum to net 0. However, i occasionally have two stocks with 0% returns. This causes an issue whereby RANK obviously...