scores

Hi I have a table with 4 columns of "scores" its needs to be laid out like that as its 4 phases of a cycle. What i would like to do is rank the scores across all 4 columns. Column C, F I and L have Scores and i would like the Ranking next to those scores in Columns D,G,J and M. i'm doing...

I have a large data dump of 1200+ students and all their test scores. What I want to do is output a results (true/false) for each agent that had at least 2 consecutive test scores above 75% Example ID | Name | Test Score 123456 | Student A | 76% 654321 | Student B | 86% 435261 |...

I need to figure the average of the 4 highest of 6 quiz scores for a class that I am teaching. I drop the two lowest scores, but those are the two lowest submitted quizzes; a zero (= student skipped the quiz) does not count as one of the two dropped. So: a sample student has these six cells...

Hello, I am importing data from an html site that uses colons to separate data (i.e. soccer results with scores 1:1, 2:2 etc) in each cell. When the import request goes through, it makes the 1:1 scores as a time of 1:01:00AM. I am wondering how I can either get it to show plainly as '1:1'...

Hi guys, For the best part of 6 years I have toiled with updating 2 spreadsheets (one for manchester united football club's league games and one for their cup games). I receive scores from email and whatsapp from 26 members who predict the scores for each game and I manually input this into...

Hi All I've tried to find a solution to this but i just can't see it. using a really basic nested IF =IF(D4=1,600000,IF(D4=2,525000,IF(D4=3,375000,IF(D4=4,225000,IF(D4=5,100000,IF(D4=6,25000,0)))))) I am only getting a return of 25000 or 0. I have this replicated in D4 to D7 with the scores...

Our school purchased a program that offers different courses for our students. My class has 15 students. When I download the scores in excel, the program doesn't separate the scores by teachers or by groups rather I get the scores of the entire school. the report even shows scores of previous...

Hi all, this is my first post so please go easy :) I have a Speedway grand prix sheet i have put together with basic formulas. Not happy with that i have tried to go a bit further and have now gotten out of my comfort zone. As u can see from the sheet the AC column totals up the riders score...

Hey All, I am in some desperate need of help for a Ryder Cup (Match play) style golf tournament. We are doing a combination Ryder Cup team format over the course of 3 days, 8 players, teams of 2, as well as have an individual component to scoring our Net for a cash prize at the end. I have...

I'm having difficulty with the formula to find the lowest 5 of the last 6 golf scores listed in a column. The scores are auto-populated from another sheet so each cell with a score already has a formula in it. I will also have weeks when someone doesn't play so blank cells are common. My...

Hi, I'm looking for a formula to insert into cell AE8 that will calculate the average of the scores in the table based on the two variable criteria entered into cells AE5 and AE6. The table size may vary (number of columns and rows) but the headers will always be unique. So, in the example below...

Hi, For my own use and to replicate a childhood game I am trying to construct a cricket match. So far I have: A21=INDEX(A:A,RANDBETWEEN(1,COUNTA(A:A))) to return scores between 0 - 6 including OwZhat Then =IF(A21="OwZhat",A19,"") which in turn triggers A19 =CHOOSE(RANDBETWEEN(1,2),"OUT","NOT...

Hi everybody. I have a table of data that tracks scores for players on a team. the data is separated by dates. how would I use the AverageIF function to average the last 5 scores for a player from the data set? thanks

hello i have two columns of data, Column A # of changes- its about 900 rows of data, and it provides the # of changes that have taken place, so it may say 0,1,2 etc Column B : CES SCORE- again 900 rows, data can range from 0%-100% in column C i want to average the # of scores in column B where...

Hi All, I have created a band competition recap which list schools and their scores. The groups are entered based on performance time, then ranked within their class. I want to sort the groups by "place" located in column AX. The problem is that I have another row underneath the row with...

Hi! As a new member I've search thru the forum in the hunt for an answer to question, but no luck so far. There are som similar threads but none with a specific anser to my issue. I've created a workbook with a lot of soccerscores. At this point I'm forced to input the scores manually, but I'm...

I have a list of student names in Entry!B8:B400 ... not all cells in that range will have a name in it I have a score (somewhere between 400 and 200) allocated to each of them .. the scores are in Entry!CA8:CA400 Some students will likely have the same score as another student, so scores...

<tbody> Area 1 Area 2 Area 3 Area 4 Area 5 Lowest 2nd lowest 3rd lowest 1.2 1.6 1.2 1.4 1.7 =IFERROR(INDEX($A$1:$E$1,MATCH(SMALL($A2:$E2,1),$A2:$E2,0)),"") =IFERROR(INDEX($A$1:$E$1,MATCH(SMALL($A2:$E2,2),$A2:$E2,0)),"") =IFERROR(INDEX($A$1:$E$1,MATCH(SMALL($A2:$E2,3),$A2:$E2,0)),"") 1.1 2.8...

I'm trying to figure out the best layout for this table (using Win 10 Excel 2016), but I'm not sure after having tried a bunch of different things, so if anyone has any recommendations, I'd be much obliged. See a couple quick examples I created below. Example two seems my best bet as I can...

Good morning I am working on Excel 07. and need to do the following For a 12 team sports league that i want to caculate the teams total score for PTs for and PTs against I have a Macro puts the teams total score in AE5:AP5 (Team 1-Team 12) I would like the teams score to be added to cell...