ranking

I have a problem and have tried a couple of things, without any luck. Does anyone have any solutions.... I have 3 Sales guys, A, B, and C and they have all made sales and by Sales guy I want to stack rank their sales (highest =1 to lowest= X): Sales Guy Sales Stack Rank A...

Hi, I've seen a thread with a similar question but the solution didn't work in my situation. I have a table that looks similar to this: Name Role Month Avg Rank Joe A 1/1/2016 97.0% Tim A 1/1/2016 94.1% Ann B 1/1/2016 96.5% Bob B 1/1/2016 94.0% Sue C 1/1/2016 85.0% Joe A 2/1/2016 100.0%...

Hello, Trying to build a ranking formula that takes into account total score for duplicate identifiers, as well as a tie-break for the duplicate total scores. The goal is to return a rank for each, without skipping any ranks, with duplicates scores rankings based on the Tie-break. However, the...

The short version: I am running into a problem with duplicates in Ranking. Details: I have a listing of about 160 clients listing the number of purchases each month from each. These clients are ranked, using the formula = IFERROR (RANK (O3,O$3:O$161,0 )," " ) (spaces added to prevent...

Hi All, I need help with an excel formula which will allocate serial numbers a set of numbers in a column. The data is as follows. <tbody> YES/NO CODES SERIAL NO'S YES 12345 1 YES 12346 2 NO 12356 YES 12345 1 NO 12356 YES 12357 3 YES 12346 2 YES 12346 2 YES 12347 4 YES...

Hello, I am trying to write a formula that ranks the team members based on their points, per week, within their own teams. <tbody> Team Member Team Week Beginning Points TMA Team 1 1/01/2015 12 TMB Team 1 1/01/2015 11 TMC Team 1 1/01/2015 15 TMD Team 1 1/01/2015 9...

Hey Guys, Thank you for reading my question(plea for help), I really appreciate your help (I'm on my knees, begging) I am making a bowling league excel sheet, I will have 10 - 15 teams. Each team will start of with a rating. - There may be no games on a particular day, or more than 1...

I'm looking for help developing a formula that will return the results... 1st, 2nd, 3rd, 4th, etc 51st, etc. <tbody> Date Name Department TO Variance CC! CC2 CC3 5-24.99 25-49.99 50-199.99 200-399.99 400 or more YTD 02/27/15 Bill BAR Bar Manager (99.95) 6th $50.00-$199.99 9 3 6 0 0 18...

Hello everyone, I am having major issues trying to determine if there is a way to calculate a certain function. Backstory: I have a list of individuals in a spreadsheet who appear repeatedly every time they make an error in a specific database. I report this information to an executive who...

Hello Everyone I am struggling to find an answer on the forum of how to rank multiple criteria if some of the criteria is (the higher the score the better) and some (the lower the score is better). Here is an example of what I am after: <TBODY> A</SPAN> B</SPAN> C</SPAN> D</SPAN> E</SPAN>...

Highest score wins. We determine who is the champion(s), 2nd, 3rd winner etc. If two winners have the same highest score, both are 1st winner. The next will be 3rd winner. If three winners have the same highest score, three are 1st winner. The next will be 4th winner. The same logic applies to...

Hello All, in my excel sheet i need to rank different sellers, according to "results points" given so far (points are given in ascending order : higher points = best valuation). I tried to use the "RANK" formula, but it's giving me some strange results. At the moment all the sellers have a...

Hello, i am puzzled with this problem... I have a series of raws with 7 numbers in each raw; sums may vary a lot from raw to raw, and also differences between one number and the other in a same raw. Now, i need to obtain a much simpler distribution of scores, so reducing differences. I would...

I am new to the forum and have been struggling to figure out how to rank the cheapest price by location and product. Essentially, I am trying to identify which supplier has the cheapest price for a specific location and product and rank that grouping by the cheapest price. I am not good at VB...

<tbody> A B C D 1 Name Bonus Years of Work Rank Per Bonus 2 John 50 35 3 Mary 50 15 4 Tommy 60 20 5 Jack 50 16 6 George 70 16 </tbody> So I know how to rank normally, in D2 I would type =RANK(B2;$B$2:$B$6;0) and then just drag it down how much I need, but here I want the...

Hi All, I am struggling with getting this to work using Excel formulas. If anyone can help, would be highly appreciated! I have a table that stores Matches between players and records the Winners/ Losers Name. It also shows the State Ranking of the Losing Player. Now I need to create a list with...

I have peer values that I want to rank in a single column to benchmark them against each other. I would also like these to include percentile ranks of the overall peer group, but I want the chart to include only values over a certain level. For example, these are some of the values I want to...

The database is columns 'A' and 'B'. Numbers in column 'A' are related to numbers in column 'B' and this relationship needs to remain when the numbers are reorganized in columns 'C' and 'D'. I would like to rank the pairs of numbers into two new columns ('C' and 'D') with the numbers in column...

I have a list of Customers in Column A , their Revenues in Column B, Month Over MonthGrowth in Column C. Is there a way in Column D to Rank the Customers in terms of their Month over Month Growth, but exclude bottom 10 % in terms of Revenues from the ranking?<o:p></o:p> I know that I can...

Good morning, I've been trying to figure this out for a while, but haven't been able to find any resources. Thought you guys will be able to help me solve this. I would like to create a spreadsheet that creates kind of a leaderboard based on geography. To illustrate: Tab 1: Drop down menu...