score

I struggled with this for a week and looked on multiple sites for help. I need to create a chart that has multiple straight lines, each representing a person's beginning and ending score. I created a grid that lists the people in each group (groups are selectable) and I pull the data from a...

Hey Folks, Newbie to the community here, trying to update weekly football scores that i copy and paste from a website. (covers.com) The football scores come in this format W/L (win or loss) and the score with a hyphen in the middle. "L 31-33" would be a loss as the team scored 31 points and...

Hi - I am having some problems with the following (which I am trying to solve in stages). Ultimately I want to cell to read (spanning over 2 lines); Final Score October (if weekly) or September (if monthly) The text 'October' sits in cell M2 of LastGame worksheet and is subject to change The...

Good Afternoon, My data is constantly updated (new rows) and i'd like to be able to average the last 3 scores (SCORE) for each Student (STUDENT) - in the example below Student A would show an average of 91, 71, 74. The issue arises when I add new data, I need this to update on the fly. This is...

I am creating a pivot table that feeds from a loan data table to track some installment loan data. In the rows I have "Type" (Auto, Motorcyle, RV, etc.) and "Model Year". In the columns I have customer credit score. I am wanting to group the credit scores in the following ranges: >=726 725-691...

Hi, hoping someone can help with a formula. I have two tables, one on the left with players, scores, team and account columns. this table has a thousand+ rows. On the right is a cut of a pivot showing average score for people in those teams/account types. I want to find the players with the 5%...

Hello, I'm wondering if it is possible to store more than one number in an array. I'm hoping I can reduce the size of my large score sheets by storing the scores of each student in one cell where for example the first element would be math score, the second physics score, the third chemistry...

Hi all, I am having a bit of an issue while trying to analyse data I have generated from using Dartfish (sports analysis) software. Firstly, I am analysing a tennis match and with the software there is a score panel tool which allows me to track games, sets, and tiebreak scores. When exported...

<tbody> A B C 1 NAME SCORE WANT THIS 2 Cathy 75 Dan 3 Bert 50 Cathy 4 Cathy 75 Alan 5 Bert 50 Bert 6 Alan 50 7 Dan 100 </tbody> Hello all. I'm looking for a formula for C2 (copied down). The formula returns a unique distinct list (removes duplicates), in descending order of...

Hi Everyone, OK so on my welcome sheet I have 6 questions all need to be answered before you can move on. so what I need is this. The Titles are in column D in colum G I have a 1 if its not filled in and a 2 if it is. So I want a macro that when runs looks at these cells G14,G16:G18,G20 only...

I'm trying to figure out a way to do the following, and forgive me if I'm posting something entirely too complicated. Sorry for any time wasted. But if you want to help.... Lets assume I have a potential pool of 500 employees. Each employee has a productivity score, and a salary. The total...

<tbody> Score Rating 80 45 </tbody> What formula do I use to get the rating to show up as Below, Approaches, Met, Masters based on the following: If score is 40 or less equals below If score is between 41 & 62 equals Approaches If score is between 63 & 78 equals Met If score is 79 or...

Hi, I have a number of nested IF formulas that aren't working and I feel like I've tried every variation but still can't craack it! Any help would be gratefully received! SO in the cell next to the formula, I have 3 options and depending on what is selected, I then want it to generate a...

You guys have helped me a couple of times recently. I hugely appreciate it but I'm stuck again. Apologies. So P2 is John and S2 is David in the next cells along there is a figure so Q2 is 4.5 and T2 is -4.5, I need a formula to look at the values in Q2 and T2 and know that T2 is the lowest...

It's Friday Evening and my brain is melted, I can't think and this is providing me with errors which is incredibly frustrating...

I am wondering if there is a way to identify a cell in a formula by essentially calling it "the cell to the right of X" I have a table of multiple test scores from multiple people and the time it took to complete the test. For simplicity it looks like this A B C...

Hi I am looking for some help, been fiddling with excel most of last night but not any closer to solving this little problem. Lets say I have some test results, based on the % achieved you get some points (which will be used later in combination with other test results). Any score under 60%...

Hi all, <tbody> A C D E R S T 1 Paper Rank Div Rank 1 Div Rank 2 Score Diversity Score 1 Diversity Score 2 2 Andover 1 #REF ! #REF ! 80 80 #REF ! 3 Andover 2 #REF ! #REF ! 64 54 #REF ! 4 Andover 3 #REF ! #REF ! 62 62 #REF ! </tbody> In Column C, the formula is...

I would be so grateful for your help. I have been searching for days and am at a loss as to how to even find the answer. I need to determine whether a group of Primary School children are Below, At or Above Level based upon their score and where that lies in relation to their age. I can either...

Hi folks, I am running a marking centre this weekend and I wish to sum track 'live marking' of exams over the course of the day. I have 3 teams, each correcting one exam (Exam A, Exam B, Exam C). However I only wish to see a candidates overall result once a score has been posted to each of the...