rank function

Good day Mr. Excel users, Searching in the forum and online help have not helped me figure out how to use worksheet function Rank but using members of a VBA array as arguments. I made a simple example to work with. Here is what I have so far: Sub ranker() Dim c As Variant, allVals() As...

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...

Hi, Looking for some assistance with ranking. I have a scenario where i have a pot of money to split based on ranking. I can use the rank function but if the value i am ranking against is duplicated i want to be able rank equal but share the pot accordingly: Person 1; Score Value = 4; Rank =...

Hello, I have encountered a problem and I cannot find a solution to it. My Excel knowledge is good but it lacks certain areas. I have a list of people and their scores. I need to order them in descending order. Everything is basic so far. My issue is as follows: The requirement is that if any...

I have a spreadsheet where column A has the company ticker, Column B the name, and Column C has their stock's change in performance. There are a total of 1000 rows of data, column C can sometimes be the same, for example two stocks could increase by 5%. Out of the 1000 companies I only care...

Hello and thank you in advance if you are able to assist me with this project. I initiated it several years ago as a spreadsheet solution to help with my ADHD. It's supposed to take a list of items and rank them in order of priority based on a number of factors. The project was never completed...

I have a set of data which I need to attach a fairly complex rank to. I have the headings: Sales Person, Company and Status. Firstly I need to separate the ranking by the different statuses, then rank first by Sales Person then Company. All are text values so will need to be ranked in...

Hi, I need help in ranking data in non-continuous rows. I have two columns. Column A has numbers that need to be ranked. For example we will take the numbers 100, 75, 100, 75 & 50 in that order from cell A1 to A5. The second column has the letters Y or N which will be arrived at based on...

I have a College Bowl contest going and I want the players to see how they rank in order 1-33 with the other players in the contest. Her is my formula for the players: =INDEX(A$1:CR$1,1,LARGE(IF($H$83:$CR$83=D89,COLUMN($H$83:$CR$83)),COUNTIF($D$89:$D89,D89))*1) *A1-CR1 are the names of the...

Hi, I have an excel file with the below format. Now i want to put rank for the event. Here I am manually put the rank (rank 1 Only) on the last field. Please can you give the formula instead of manual? THanks <tbody> Event Time Details lay RANK Catt 20th Oct 13:40 5f Nov Stks 3.3 1...

Hello, Does anyone know of a way to get the rank of an aggregate of multiple columns across sheets in a workbook please? I found a non-workable but good formula: =SUMPRODUCT(--(A$2:A$10+B$2:B$10>A2+B2))+1 BUT! it doesn't allow for a lookup/search variable - the columns are "locked" it does...

I have a list of students with marks and their date of births. If their marks tie, whoever is older gets the higher rank. how do I write a function for this?

I have a spreadsheet that populates itself from individual stock data downloaded and subsequently calculated. The data is sorted per Sector Category - each sector may have one or more than one hundred tickers within it. With the excellent help from those on this forum I have been able to get the...

Is there a VBA code for the Spearman's Rank Correlation Coefficient, where its syntax is =Spearman(Range1, Range2)?

Hi: I have a table with 3 columns (NAME, ROOM, GRADE). I would like to be able to have a 4th column using the Rank function to have the NAMES ranked by GRADE but depending on the ROOM. So, in the 4th column, I should have 3 NAMES ranked as 1 if I have 3 ROOMS. The ROOMS are not numeric. They...