score

Didn't quite know how to word the title... I keep a spreadsheet of music, albums that have come out every year going back to the 70's. As I listen, i score them. One sheet for each year, column A is the artist, B is the title, C is the score. I'd like to put a worksheet in front of all the...

Hello! I'm working on a code and have come upon something that I hope has an easy way to do. In it, there are 3 cells in the workbook. Each cell can only have 1 of 3 possible string values in it. For this example say A, B or C. Depending on the combination of letter, they receive a different...

Hello, I'm trying to weight a score so that the closer it is to the top the smaller the increments are. For example, if someone scored 2.1 then they would get 100, if they get 2.5 then say 99, then 3.5 might be 96 etc. the further away you get from 2.5 the more severe the drop in score. When...

This might be difficult to explain, but I'll give it a shot. Basic overview is a table where numerical scores are entered. The scores are ranked 1, 2, and 3 based on the "Div" (Division) and the Model of the car. DIV is located in A68 and Model is Located in A67. The code below is for...

I have two columns of data. The first is a count of respondents. The second is the average score for those respondents. I need to sort the second column into numerical value, highest to lowest. So far, so simple. The area I am having an issue with is that if the number of respondents is less...

So I am creating a bet sheet to track all of my bets for a golf tournament. The sheet has the bet amount and then a cell for my score and my openents score. I was trying to figure out a formula that stated that IF my score was higher than the opponents score to return a negative number (loss)...

Hi. Please see ‘Example’ file via the link, below. https://1drv.ms/x/s!AtIvkRgReIvwgRcNSvXr5zlzQZXA My problem relates to columns BF and BG in certain cases. In cases where the finishing position is the same in column BB and BE (sub-event #1 and sub-event #2: green highlighted area), I...

Hi, I need help with a formula that is not returning the correct outcome. I work for an awarding body and to pass one of our qualifications you need to achieve a minimum of 60% and at least score a 1 in all 12 questions answered. If you score 60% but score a zero in one question, you are still...

Hi, running PowerPivot in excel 2016, say I have a group of 10 persons, and for every day the 10 persons record a score. I'm wanting to find how many days (or rows given that each row is a different day for the individual person) since each person recorded a score of say 60. So in the example...

Hi, Can I have some help. I want to create a list of unique names based on their lowest score e.g. Surname forename Score score Smith Dave French 3 Smith Dave French 1 Holland Fred Science 2 Holland Fred...

Hi I have an audit matrix document which calculates %age scores for multiple sites. The score should always show a full number (i.e 80%, 90%, etc...), and I am happy for standard rounding to apply (i.e round down for .4 and below, round up for .5 and above) However, I don't want this to apply...

I have a bunch of engineers who get assigned work for each day and I have come up with a scoring system for how well each is utilized on a particular day. What i would like the is overall average score for each day for all engineers, but getting something different that is an average of...

hi am finding it hard to explain it but it should be easy in the example <tbody> A B C D E F G 1 Score Level Score Level 2 10 AA 10 =????? 3 20 BB 15 AA 4 50 CC 18 AA 5 100 DD 25 BB 6 200 EE 70 CC 7 </tbody>

Hi I have a row of test scores and I would like to show in the same cell next to the score an arrow that points up if the score is higher than the previous cell and an arrow pointing down if it's less. If the score is the same either an = or nothing. Can this be achieved with conditional...

Maybe this forum not the appropriate place to post this (?), but I have not found any other websites raising the issue. My question is about to which extent does the copyright of questionnaires extend to a simple unofficial Excel scoring calculator? The thing is, I work as a neuropsychologist...

I have scoured the internet and I cannot find anyone trying to do specifically what I am doing in Excel, so hopefully you can help. Consider the following table (Range"A1:D16"): <tbody> <tbody> College </tbody> <tbody> Score Range Min </tbody> <tbody> Score Range Max </tbody>...

With the help of this Forum I managed to build an Inputbox code that enables me to input golf scores for each player in turn. With a blank score entered if the player didn’t play. See code below. If possible, I am now wanting to use a UseForm to do the same thing. On the worksheet, each...

Hi guys i have kpi results data below for one person <tbody> Name Alex win rate 56% renewed 5% answered 25% over all Score </tbody> I need to create a formula or come up with away to calculate the over all score. To get the over all score you need to score each kpi first and then...

Hello all! It's my first post, so please be nice :-) I'm trying to create a "dashboard" which looks up a value (hlookup) in the top row of the data set and returns back a sum of its "scores" from the column to the right. I tried and failed at nesting hlookup, sumproduct, and wrapping them in an...

I would like to write a UDF that can "look up" a value in a sheet table if passed the name of the table and the search text. Here's a simplified example of what I would like to do: Suppose I have this table in Sheet1 containing the scores in a trivia game: <tbody> C/R C D 4 Amy 28 5 Brad...