rank

Hi I have 37 numbers in J5-J41, which I would like to rank from 1-37. Highest number at position 1. I’m having trouble working this out. Thank you for your help. Regards

Hi there, I have two columns of data. The first column consists of salary and the second column consists of average points per game. There are 147 rows of data. I am trying to choose the top 6 BEST averages while keeping the salary of the 6 chosen to not exceed $50,000. There may be times when...

Hi, I have file which has all employees with their objectives. What I need is to count how many objectives per employee, then assign number from 1 to 5 so I will end up by including up to 5 objectives per employee. Column A (EE ID) Column B (Objectives) Thank you! Z

Hi, I have a formula to Rank data, say in Range("A1:A5"). The formula is: <a1) countif($a$1:$a$5,$a$1:$a$5&""))+1<a1)="" countif($a$1:$a$5,$a$1:$a$5&""))+1[="" code] <a1) countif($a$1:$a$5,$a$1:$a$5&""))+1[="" code] <a1) countif($a$1:$a$5,$a$1:$a$5&""))+1 SUMPRODUCT(( $A$1:$A$5 < A1 ) /...

Hi, i'd like to ask, since this is bit confusing, i don't know how to rank like this case. my goal is to keep the rank in order, not skip it even if there's duplicate. thanks a lot for your help

I want to create the ranking based on 3 columns without sorting method. How can I make this in excel? I saw people using rank and sumproduct, but can you teach me? https://imgur.com/kG5eVlF

Hello All, So I am trying to rank orders for items in our orders spreadsheet based on when the order was placed: <tbody> Date to Ship Item Number Order Placed Rank 3/4/2019 ABEL MAG18 7/21/2018 1 5/13/2019 ABEL MAG18 12/14/2018 2 6/3/2019 AMEL COS10 11/22/2017 1 3/25/2019 ARON VIK18...

Hi all, The rank function is driving me insane!! I am trying to add a rank column to my table, but to ignore the 0 values, not have duplicate ranks and show the lowest value (which isn't 0) as 1. So far, I have managed to do everything except for getting it to show the lowest value as 1. I...

<tbody> YEAR CLIENT STATION STATIONCNT STATIONCNT RANK 2019 A CHI 8 1 2019 A LAX 2 2 2018 A DAL 7 3 2018 A SFA 25 1 2018 A NYO 8 2 2018 B SFA 1 4 2018 B CHO 10 1 2018 B CHI 4 2 2019 B LAO 2 3 2019 B LAX 23 1...

Hi, Please can someone assist, I am trying to create a ranking based on multiple criteria. Each section has been ranked now I would like to see who is leading in terms of a "FINAL RANK" based on all the ranks. please can someone assist me? Please can someone assist with a formula <tbody> MBR...

How do I do a ranking in Access? May Query Produces <caption>qryWest HI Dairy</caption> <thead> Vendor MaxOfItem Expr1 Expr2 </thead> <tbody> 520215 447036 58 $1.08 520215 447036 1 $10.28 520215 447036 1 $10.64 </tbody> <tfoot></tfoot> I need to have a...

Hi Everyone, Would like to ask correct formula on how to deal with ranking tie ups. Thank you in advance! Below are my sample data and desired result <tbody> Employee ID Sales Person Sales <tbody> S00001 S00002 S00003 S00004 S00005 S00006 S00007 S00008 S00009 S00010...

Hello, I just finished doing assessments for my 37 Athletes and now for my assessment report my team leader wants me to make each criteria worth the same amount of points as the percentage it represents. For example Jumps are worth 20% and I have 22 boys and 15 girls so I want to allocate a...

I need to rank a set of data in a UDF. For example, if the data set is: <colgroup><col></colgroup><tbody> 70 #VALUE ! 54 41 95 </tbody> then the command Application.Rank results is an error. Is there a way to ignore #VALUE ! or #N/A and still rank the rest of data? I need a VBA solution.

Hi, I have loaded a table (named "Data") into Powerpivot and would like a measure to rank by Product in each city using a ref number. I also want this rank to stay even if I filter later. <tbody> City Product Ref RANK I want Sydney Bike 100 1 Sydney Bike 102 2 Sydney Bike 105 3...

Hi, I am trying to rank the data below using the duplicative values in column A. So for instance 1061012 has 3 values in column B (10.87%, 11.89% and 10.66%), i want to rank those 1-3 then start over with the values for 1061414 (1-3). I have written some count ifs but not sure how to rank...

Hi, I'm using a O365. I think I'm asking the impossible but will give it a try. I have a sheet that goes down to 3000+ rows. In Cell A1 is a time, the same time goes down to cell A16. I want to rank Column B1:B16. That part is the easy part. I then want to rank Cells B17:B28 as Cells A17:A28...

I need to create "League Table" of anything over a year old, but it needs to be sorted by the largest volume. I have tried to use RANK, but when I reference it to Cell B which contains the volume, it does not want to work! =IF(D2>TODAY()-365,"",RANK(B2,$B$2:$B$21,1))

I have a spreadsheet with my utility bills for every year in separate columns. I would like to put a rank next to each year. How could I rank each year by using every other column? When I add a new column every year I would need the formula to change in all the previous years to use the new...

Hi All, I have an initial list. I would like to be able to display this initial list 3 times sorted on different criteria each time as below: <tbody> initial list list sorted on column C list sorted on column D list sorted on column Total <tbody> Rank Name C D Total 1 name1 10 20 30 2...