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

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.

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.

I'm using Excel to keep track of my bowling scores. I can do the basic stuff with sums and averages and whatnot, but I need some help with some more complicated stuff.

I want to account for when I bowl more or less than 3 games a session. For example, if I only bowl one game and get a 180, I don't want it to think my average is 60.

I already started a basic spreadsheet if anybody wants to help me with what I'm trying to do. (Feel free to add more stuff like graphs and whatnot and make it look better if you feel like it)

I run a golf society and need to set up a golf aggregate sheet that will allow me to enter the players weekly scores and the sheet will then look for the lowest score entered for each player and replace it with their score of this week.

I'm Seeking in InRegards To Working Out How To Display Multiple Leaders Within The Same Cell Based Apon There Score In A Game Of Golf, Or If This Cant Be Done Perhaps A Message Saying "Multiple Leaders" So That It Is Known That Its Not Just The One Persons Name That Is Been Displayed. I Have Attatched The Document I Have Been Playing With While Trying To Work It Out Before Making A Big Sheet.

As You Will See "Daniel" And "Paul" Both Have The Same Score, And Below In The Summary It IS Currently Only Showing "Daniel" As The Scratch Leader, Is There A Way Of Getting It To Show Them Both As A Leader, EG: "Daniel, Paul", Or As Said efore Just Saying "Multiple Leaders" Thus Having To Manual Go Through Them ( The Fist Option Would Be Better As There Will Be Approx 85 Names In The Final Sheet)

I have a paper-based scoring sheet that we use to determine a rating category. I cannot figure out how to convert this scoring sheet into a lookup region and use some type of LOOKUP formula to determine the rating. I have looked at the various Grading examples on the Internet that show you how to look up a grade, based on a score, but they only look up a grade, based on a single input (the score).

Here I have two values going in--the person's age and their score, and I need to look up the rating, which is the column heading.

Can anyone point me in the right direction?

I've attached a sample spreadsheet which shows the original scoring sheet.

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.

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

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

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.

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.

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.

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.

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.

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.

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

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.

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.

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

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.

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.

I am using a vlookup formula to a series of data sets. I am trying to get something so that it will display the relevant score for that site. However the lists are not the same size, how do i get a vlookup to read a score for a site if it is the the array but display "0" if the site name is not in the array?

It is coming up with #N/A and I can't do anything with that.

I have a scorecard created in excel 2007. All my end users are using excel 2002. Now I want to build a scorecard in Excel 2002 like what we have in excel 2007. Is it possible.

I want to display the traffic signals and 5 level indicators (arrows), based on conditional formatting.

This is out of box in excel 2007. But how do I achieve this in excel 2002? Is there a simple method?

I tried to use an array to calculate the mean score for a column: if a cell has a value 'A', then it is assigned a value 1, if 'B', then 2, if 'C', then 3.

s/s is 325501 rows deep. Column C contains names. Column J contains scores. I need column N to give me the highest score a name has previously achieved. (please see small attachment for illustration). If i can get a formula then I can fill this down.