Score & Rank Results To Cut Off Point

Jul 17, 2007

I have a column of unsortable percentage data. I need to allocate a point in a neighbouring column to all those percentages up to a cutoff total percentage.

Not very clear because I can't put it into words. Essentially, as the column is not sortable, I need to identify the highest percentages listed in the column down to a cutoff. Makes more sense if you observe the simple Excel data.

View 9 Replies


ADVERTISEMENT

Rank Based On Score

Feb 23, 2010

I have a workbook with two tabs: Results (containing exam results) and Percentile (containing percentile rankings based on scores). There are different rankings for different exams.

I need the percentile ranking returned (on the Results tab) based on the exam result for each student. e.g. for exam M111 a score of 36 would return a ranking of 95, a score of 18 would return a ranking of 35, etc. I've attached a sample workbook.

View 4 Replies View Related

Rank Change And Corresponding Point Difference

Mar 8, 2009

Column A has names and Column B has points in descending order for the names in A. Columns C & D will have names and points, re-sorted for points descending order.
Column E will report if there has been a change in the ranking of the name and by how much. Column F will report the point difference for the names, regardless of order. I have attached a generic example, without any attempts at formulas. I am working with over 600 names.

View 4 Replies View Related

Rank For Wins Then Point Difference

Feb 9, 2009

A formula for ranking two sets of columns and four rows. I have column A with the names Sid, Dave, Marty, Steve. Column B has -4, 5, 4, 2 (thats actually the point difference). Column C has 1, 2, 2, 1 (thats actually winning games). I want to rank them in order from highest to lowest starting with column C (winning games), then because there is obviously a draw (or as some might call it a tie) between Dave and Marty (2 each) and another draw between Sid and Steve (1 each), I would like to rank them upon column B (the points difference) after attempting to rank them for games won. So I anticipate an extra column with the following from top to bottom - 4, 1, 2, 3.

View 9 Replies View Related

Develop A Point System To Rank Things

Aug 20, 2009

I am trying to develop a point system to rank things. For eg: in the below chart, I have the follow criteria.

In a particular Cell A1, i enter a numerical value like 1.5. Then Cell A2 (Points) should show that the Points earned is 80.

If MTTR is 1.00, then the Points received by the candidate is 100. Similarly if 3.5 or higher is there, then the points should be 0

MTTRPoints
1.00100
1.2590
1.5080
1.7570
2.0060
2.2550
2.5040
2.7530
3.0020
3.2510
3.500

This is only one type of calculation. For other tables, i will have to change the criteria.

Is there any way i can set the limits for A2 as 0 to 100 and based on what appears in A1, the cell A2 should change automatically

View 9 Replies View Related

Rank Filtered Results

Sep 18, 2009

How do I rank filtered results? I do not wish to use VBA if possible.

View 4 Replies View Related

Rank Blind Tasting Results 1st To 9th?

Mar 10, 2014

We had a blind tasting of 9 different recipes for a new product (served in cups numbered 0 - 10 [cups 1 & 7 were not entered]) and asked people to participate in a blind tasting, rating the cups 1st - 9th, the 1st being the cup they thought tasted the best and the 9th being the cup they liked the least.

I have entered the tasting results in a spreadsheet which I attach. For example, 2 people liked cup 10 the best and 1 person liked cup 0 the least.My problem is working out what the products ranked overall i.e. 1st, 2nd, 3rd etc from 1st to 9th.

View 3 Replies View Related

Formula To Work Out Score Based On Score System

Aug 10, 2009

I want to see if i can make a formula that works out how a player got a score based on a scoring system. See the attached file for more details. I want this to show that the player scored or didn't score, played a full match or was a substitute, was booked or wasn't booked and was sent off or wasn't sent off.

View 5 Replies View Related

Automatically Change The Point Name To Match The Point Name In Column

Dec 10, 2008

I have a pivot table as shown below which is pretty straight forward however I am trying to create a macro that will automatically change the point name to match the point name in column E then copy that resulting dispaly to another sheet then pick the next point name in line and do the same thing and repeat for 50 rows, so my end result will be 50 pivot tables ready for printing. I can do this manually but I am trying to make it automatic...BTW the point names in column E change everyday but the pivot table supports the name changes.

Option Explicit
Sub PointName()
Dim Ws As Worksheet
Dim Rng As Range, Cel As Range

Set Ws = ActiveSheet
Set Rng = Range(Cells(2, 7), Cells(Rows.Count, 7).End(xlUp))

For Each Cel In Rng
Ws.PivotTables("PivotTable1").PivotFields("Point Name").CurrentPage = Cel & " "

Ws.Columns("A:B").Copy
Sheets.Add
With ActiveSheet
.Paste
.Name = Trim(Cel)
.Range("A1").Select
End With
Next
Ws.Activate
End Sub

I turned it off for a while and when I turned it back on I am getting an error
Unable to set the _Default property of the PivotItem class

Debugger is highlighting

Ws.PivotTables("PivotTable1").PivotFields("Point Name").CurrentPage = Cel & " "

View 9 Replies View Related

Rank A List Then Re-rank The List While Excluding Certain (or By Criteria) Items

Dec 30, 2013

I'm trying to Rank a list and than re-rank the list while excluding certain (or by Criteria) items

Vendor Co
Cost Fee
Rank

Vertox
500
4

BV
1520
3

[code].....

View 4 Replies View Related

Multiple Ranking: Rank The Values In Column B And Then Rank The Values In Column C

Feb 11, 2009

What I am trying to do is give the rank in column D based on the values in columns B and C. Some of the values in column B will have then same rank, and as such I want to add further criteria on which to rank them. I would first like to rank the values in column B and then rank the values in column C, which should give the rank in column D. For example Dog and Frog have the same value of 400 from the Non UK column. Therefore, rather than having these as both rank 1, I want them to be ranks 1 and 2, so want to add another criteria (UK). As Dog is greater than Frog in the UK (i.e. 10>7), I would like to rank Dog as 1 and Frog as 2. Goat will be ranked as 3 because it had the thrid highest value in the Non UK.

ABCD
1Non UKUKRank
2Cat20055
3Dog400101
4Eel200114
5Frog40072
6Goat30023

View 4 Replies View Related

Tally Score

Mar 14, 2007

im using spreadsheet works which seems to be very similar to excel. i am making a table full of numbers and i want to count how many times the number 1 appears and for that amount to be displayed.

View 11 Replies View Related

Compute The SCORE

Jan 20, 2009

i was assigned to make a computation for our individual scores using this:
EMPLOYEES A-N

inputs:
SURVEY(0-100)
LH(lost hour)
AHT(average handling time)

compute for:
SCORE
RANK

the SCORE has a total of 100%
so to get the SCORE, each input gets a percentage: SURVEY=40% LH=30% AHT=30% then added.

but the thing is LH and AHT has an equivalent.

LH
0 to 1=100
1.1 to 2=90
2.1 to 3=80
3.1 to 4=70
4.1 to 5=60
5.1 above=20......

eXAMPLE:
EMPLOYEE A
SURVEY(0-100) = 33.00
LH(lost hour) = 12.00
AHT(average handling time) = 14.20
SCORE = CODE
RANK = CODE

now for the rank i just use the code =RANK(SCORE A, SCORE A:SCORE N)

im lost on how to compute the SCORE though coz i can just use =((SURVEY*40%)+(LH*30%)+(AHT*30%))

but the one that needs to be on the LH and AHT are the equivalents and not the inputs.

and there is 1st 2nd and 3rd place. the name of the top 3 employees should be shown under the table.

View 10 Replies View Related

Name And Score (rankings)

Nov 17, 2007

i have a list of names in column A and a corresponding score for each name in column S.
on a stats sheet B10:B15 was trying to make a top 5 list using =LARGE(Week1!S15:S46,1) ... with Large i am able to get my top 5 from the week1 sheet but how can i assign the corresponding top5 persons from column A15:A45 in week1 to the stats sheet in column A10:A15

View 9 Replies View Related

Score Sheet

Apr 27, 2009

I am currently working on a score sheet with list of question.

I have:
On Sheet 1 (will be hidden later)
List of 14 questions (e.g. question 1 = 6 possible answers, for answer 1 is score -2, for answer 2 is score 7... etc).
In column C are possible answers, in column D are the score values.

On Sheet 2 (will be visible for participants)
Drop-down list based on Sheet 1 questions (Sheet 1; Column C)
I have set Cell link for each question so when you choose the 3rd answer, there is number 3, but I need to set different values based on Sheet 1, could be that 3rd answer is score 12. I do not know which function to use (I tried IF, but to me it seems too long and difficoult).

View 9 Replies View Related

Bowling Score

Feb 22, 2004

I've seen a few bowling formulas within mr. excel but nothing in code. so i tried it and the only problem i have is when a player strikes.....then the code should add the next two balls thrown..... it works if the next two are strikes but not if there is no 'mark'. So basically its not adding the second ball. The code looks right unless I'm just missing something. heres the code....

View 9 Replies View Related

Results Show Results Of Formula, But Should Be Blank

Jul 27, 2006

I am trying to create formula that will show overtime worked in a given day. The code I am using is a simple one ([ cell - 8], for hours worked). The problem is when the time cells are blank/not used it shows a -8 in the cell. what I need to do to create a code that will eliminate the -8 from showing. The cell its self is taking the result from another cell with a formula and then subtracting 8 from the result of the formula in the other cell.

View 2 Replies View Related

Score Using Data Validation?

Mar 16, 2005

I am using data validation for a drop down list e.g Good, Average, None. What i want is when a user selects for example "Good" i need a score to be automatically entered into another cell so that i can then do some calculations.

View 2 Replies View Related

Modify Score Sheet

Dec 27, 2008

I have one excel file with three sheets marked 1,2 & 4

Sheet 1. is the place we add the description and the member number. When a member number is entered it gets the member name from sheet 4.

Sheet 2 is the page I need to change. Currently we can enter any score number in each box between 1 to 5. If we try to enter other numbers we get an error message.

I need to change the form so we can enter 1 to 10. Any other number needs to generate the error message.

View 4 Replies View Related

Find The Score In Worksheet

Feb 5, 2009

Should be an easy fix for experts, but I'm not one of those...

I'm trying to create a "scoresheet" in Excel where a racer has a name and an ID number on the main tally worksheet, with columns relating to their scores for each race. Subsequent worksheets have results from each race (one race per sheet), with the individual referenced by their ID number.

How do I have the main tally sheet "find" that person's score for each event in separate columns so that it can add up their totals? I tried an IF formula to find each score in the subsequent sheets, but that didn't work.

Is there a simple formula to do this? I've been achieving the results by importing the worksheets into a Filemaker database (where the ID number "matches" and updates each score), but that's a pain, and I'd rather do it all in Excel.

View 11 Replies View Related

Nested IF (score Range)

Mar 11, 2009

If Average Score is:Then return:
Greater than 89A
From 80 to 89B
From 70 to 79C
From 60 to 69D
Less than 60F

Student's Average Score
90
52
75
88
82
53
46
72
99
100
42
53
69
79
84

=IF(A9:A23>89,"A",IF(A9:A23<=89,"B",IF(A9:A23<=79,"C",IF(A9:A23<=69,"D",IF(A9:A23<60,"F")))))


A9:A23 is student's score range

I am getting the correct answer for the first one only...all others are coming back incorrect. I have been working on this one problem for over 3 hours.

View 3 Replies View Related

Find The Name And Calculate It Score

Mar 30, 2009

i need the formula in colums (l) it needs to find the agents name and the calulate the scores for that agents name

View 8 Replies View Related

Hours Missed Gives A Score

Jan 20, 2009

Trying to get a result if I missed 0 hours, I will get a score of 5, if I missed 1 -4 hours, I get a score of 4, if I missed 5 hours, I get a score of 3, etc.

0 Hours Missed5
1 - 4 Hours Missed4
4 - 8 Hours Missed3
8 - 12 Hours Missed2
12 -16 Hours Missed1
>16 Hours Missed0

I have tried a couple of things, but the formulas get way to messy & start to lose cell references.

View 3 Replies View Related

Display Name Of Highest Score

Dec 20, 2006

I'm setting up a scoring system for my rounds of golf. I have four people competing, and i want to be able to put up a page where i can display the best golfer. I have the scores and i want a function that display f.ex "Thomas" if cell d28 is the lowest number of four cells.

View 9 Replies View Related

Converting Score In Value Statement?

Dec 27, 2011

Column A has an assement score which reads 1,2 or 3 Columb B should have a value statement based on what it sees in column A

For example
A1 reads "1" ( which is a pass ) , then B1 should auto-populate with the word Pass.
if A1 reads "2" ( neutral ) B1 should read "neutral"
if A1 reads "3" ( fail ) B1 should read "fail"

For the advanced class; I can foresee a situation in the near future whereby the system needs to look at a range numbers, rather then one specific number.

For example
A1 could read "1" which is a pass , or "2", "3" etc are also be a pass.
4,5,6 are neutral
7,8,9 are fail

View 6 Replies View Related

Golf Score Board

Aug 7, 2009

I am organizing a golf scoreboard for my golf tournaments. Basically, this is what I want to do:

I would like to rank the players that are entered by their score, in ascending order. Basically, I want to take the column for "total strokes" and organize the numbers so that it will rank the numbers that are entered. If there are no numbers entered in a specific row, I don't want that "zero" to be ranked in the list. So for example, if I have five golfers but they are spread out over 10 rows, I would still need to have five numbers in the rank: 1,2,3,4, and 5, not 1 to 10, as if it were ranking the rows that have nothing entered in them.

This is how it will look:

Johnson - Strokes : 70 - Rank :1
Williams - Strokes : 75 - Rank : 3
Patterson - Strokes : 72 - Rank : 2

View 9 Replies View Related

Simple Game Score Calculation?

May 7, 2014

i can calculate finish "molkky" game scores?

These are rules; you get points after falling sticks (if any falls). Points are 0-?. Goal is to get 50 points. If you get over 50 points, then points go back 25 points.

As you see (attachment) Matts points are 51, so he has now 25 points.

View 2 Replies View Related

Distribute Number Based On Score?

May 14, 2014

I am trying to distribute the total number of sessions (cell H1) across the groups in column A based on the score of each group (column D). The number of sessions a group receives cannot exceed the max (cell H2) or be less than the min (cell h3).

View 7 Replies View Related

Getting Count Of People In Department With Score

Jun 13, 2014

See attached.PMS 2.xlsx. I have a table with data on PMS sheet and would like to have something like the example on the Example sheet using data from the PMS sheet.

View 2 Replies View Related

Assign Score To Value By Looking Up Criteria In Table?

Aug 19, 2014

I'm trying to find a way to return a value (score) based on the results in a table. I've been trying to use index and matches but am starting to think this will not be the answer for this one.

In the example attached, I have a section called report. For each project, there are criterias which need to be scored based on the values in the lookup table.

For example, project 1 has a result of 200 for criteria 1. On the lookup table 200 in criteria 1 would receive a score of 2. This result is then populated in column L as the score of this criteria.

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved