Rank My Students
Oct 28, 2007
A1 has column heading Name.
B1 has column heading Credits.
C1 has column heading Rank
A2 has student's name and B2 has his Credit value
Row 3,4,5 are blank.
A6 has a student's name and B6 has his credit value.
Row 7,8,9,10,11 are blank.
A12 has a student's name and b12 has his credit value. So on so forth.
All I need to do is rank those students in C2, C6, B12 so on so forth.
Its taking a lot of time and I am not getting any result. I tried reading about rank but it tells about asc/desc order, which I dont understand how it fits in above example. I just need rank of a student at a particular cell.
View 9 Replies
ADVERTISEMENT
Mar 14, 2012
I have a spreadsheet with my students that needs to find the date a person will be 18. based on their date of birth. I have =B27+(365.25*18) where their DOB is in B27. I have had several instances where it is correct and several instances where it is a day off.
View 4 Replies
View Related
Apr 15, 2008
i have a spreadsheet with a list of students in it and next to it i have a column with their current score and the letter equivilant (A*-U)
so say
joe bloggs 615 B
Joe bog 750 A*
etc
is there a way if I list the grading boundaries for it to work out how many marks are required for the student to reach the next grade?
boundaries are
A* 728
A 669
B 610
C 554
D 467
E 383
F 298
G 214
U under 213
View 9 Replies
View Related
Jan 28, 2009
I have a problem with counting the number of students assigned to each professor and determining the number of students who have passing grade. Let say that the passing grade is 80.
View 9 Replies
View Related
Nov 28, 2009
I have a dataset of students' grades (see sample below) which I need to compute the aggregates for.
Blanks indicate that the student did not take the subject. Aggregate is computed based on 6 relevant subjects, lowest is best.
Rules for computing aggregates:
1st subject: EL or HMT
2nd subject: H1 or H2
3rd subject: M1, M2, S1 or S2
4th subject: H1, H2, M1, M2, S1 or S2 (but not previously used)
5th & 6th subjects: Any other 2 not previously used
I'm guessing this is too complicated to be done in a function, but have no idea how to implement this in VBA.
View 9 Replies
View Related
Feb 5, 2014
I am working on an excel master marksheet which will be distributed to many teachers to fill in their students marks. How can I enter an average function that can work out the mean for those different classes. For example I'd like the main average function to be like this =average(d5:d50) but if a teacher has thirty students in his list the mean will be only limited to the marks of those thirty students. Same thing I want for the mode function and the median function.
View 7 Replies
View Related
Jan 24, 2014
Essentially I'm in charge of managing schedule for 5 students, I would like to get them to meet during their free time (free for all 5 of them)
1. Schedule has to run from 8 am to 9 pm.
2. I have all 5 individual schedules.
I want to combine all 5 into one so everyone can see their free/occupied times, it would be extra useful if I can modify individual schedules (One student's work schedule changes bi weekly).
It has to be able to show who is occupied at which time and free time for all of them. (color coding each of them would be amazing also, granted I can show multiple clashes with gradient or something similar)
I understand it involved creating individual spreadsheets and a master sheet but how to go on about it.
View 1 Replies
View Related
Feb 28, 2012
How to return ranking based on students' score?
STUDENT SCORE Rank MAY 11255 4 JACK 5262 5 TIM 432525 1 STEVEN 352332 2 HUGO 32232 3 FERNANDO 5153 6 SANDY 4556 7 SARAH 2265 8
View 1 Replies
View Related
Aug 5, 2014
How to formulate results of students in excel sheet.
From the attached picture (capture1.jpg) of the excel sheet - The rules of exams are:
1. if candidate scores 50% in all 4 papers, PASS and proceed to next year
2. if candidate scores 50% in 2 or 3 papers + borderline fail in 1 or 2 papers, VIVA VOCE exam for the borderline failed paper (Definition of borderline fail is candidate scoring 45 to 50 marks)
3. if candidate scores 50% in upto 2 papers + borderline fail in more than 2 papers, RE-EXAM
4. if candidate scores 45% in 2 or more papers, FAIL and repeat the year
The rules are in the attached picture flowchart.jpg
I am unsuccessful in writing a formula for such multiple criteria...
View 12 Replies
View Related
Oct 1, 2008
I need to find out over aged students by date of birth - now()-age started to school: DOB 8/16/2000 , Now() Age started school is 8/30/2005. Student is in grade 1. should be age 6, however, he is 8. Answer should be a little over 2 yrs.
View 2 Replies
View Related
Jan 1, 2009
Writing a single nested IF statement function to calculate the grades of the students the following rules:
If the student grade isHis/her letter grade is
Greater or equal to 90:A
Greater or equal to 80 and less then 90:B
Greater or equal to 70 and less then 80:C
Greater or equal to 60 and less then 70:D
Any other grade:F
View 5 Replies
View Related
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
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
Oct 28, 2009
I am stumped on this one. I a spreadsheet with 5 columns (Quarters, Months, Level or Rank, Name, Sales). I need to have a formula to pull in the new Level 1 (rank) after Q4 sales are summed up across months for each name. See the attachment for detail.
View 4 Replies
View Related
Feb 22, 2009
Is it possible to 'eliminate' the zero values when using =RANK? For instance, if you have data with values from +100 to -100 with some lines have '0' value, can they be ranked disregarding the zeero values.
View 3 Replies
View Related
Apr 2, 2009
I have and table that gets the average performance of couriers as a %. so.
courier 1...courier 2...courier 3...courier 4,
98.16.......100...........99.7...........99.72
i want is a formula (hoping note to have to code this) that will show which order these couriers should be ranked in by looking at the range of averages. So courier2(100) would be ranked 1st, courier 4(99.7) would be ranked 2nd etc. the end table will look something like.
courier 1...courier 2...courier 3...courier 4,
98.16.......100...........99.7...........99.72
4..............1...............3................2
View 2 Replies
View Related
Dec 8, 2012
I have a list of names that come from another sheet. I need to rank these by score and have used this formula:
[Code] ........
These names compete within their class but also within the class I need to consider (rank) a second category for example No or Yes. Also all names could be competing in the Yes category or for example 7 in the Yes and 3 in the NO. This will vary and is based on entry in another sheet.
The format is Class (column B), category (Yes or NO, Column C), Name (Column D), Score (Column S) and Rank (Column T)
If I include an IF statement =IF(S33="Yes", at the beginning of the above formula then I get all the Yes ranked perfectly. Is it possible to rank the others with the NO consideration?
View 4 Replies
View Related
Jan 31, 2012
I have a spreadsheet of raw data organised in columns and rows. one of my columns is called SERVERNAME, and each row contains the data about an incident which is related to that server.
What I need to be able to do is to firstly calculate via a formula (cannot be a pivot table) the number of instances of SERVER X, and then I need to be able to rank the top 10 servers for which records have been logged.
As an example here is some raw data:
INCIDENT
SERVERNAME
LOCATION
OS
OWNER
0001
Server 1
Japan
Windows 2008
KERLEJ
[Code] ........
Based on the above data I would like to have an Excel formula that searches through the records (Rows) and determined that there are the following number of instances of servers:
server 1 2
server 2 1
server 3 3
And then a further formula (again I cannot use pivot table) to calculate the ranking:
Server 3 3 - ranked first
server 1 2 - ranked second
server 2 1 -space ranked third
View 9 Replies
View Related
Mar 9, 2012
here is some code that I have,
Dim zima As Range
Dim Col As Long
On Error Resume Next
Set zima = Application.InputBox("Select column to paste to", Type:=8)
On Error GoTo 0
If zima Is Nothing Then Exit Sub
[code]....
Where in the formula C[-7], I need this to line up with the column that I selected via the InputBox. If I select column L then the -7 needs to change to +2. OR would there be a better way to write the formula in VBA?
View 7 Replies
View Related
May 4, 2013
trying to use the rank function but unable to use different ranges, even if I use named ranges
=rank(F1,F1:F30,F50:F60,F90:F115,0)
=rank(F1,F1:F30,F50:F60,F90:F115,0)'
It says entered too many arguments
View 5 Replies
View Related
Nov 21, 2013
I have created a sheet (call it sheet2) with 5 columns as per below snapshot. There's quite a lot of data as much as 10k rows.
Rank
Total
city
[Code]....
What am trying to do is create a summary table which shows the top 5 cities per region based on the population. This summary table will be on a separate sheet in something like the table below. formula that can lookup a region say Europe and show the top 5 cities based on the rank already calculated on sheet2 and also show the total in a separate column.
Rank
Region
City
total
1
Europe
[Code] ........
View 9 Replies
View Related
Jul 23, 2006
I have 10 sales figures in C2:C11.
In D2:D11, I want the rank of those values, with one twist.
If the value in B2:B11 is X, then that value is excluded from the ranking.
I am trying to basically do:
=RANK(C2,IF(B2:B11="X",0,C2:C11))
View 9 Replies
View Related
Apr 9, 2007
I deal with Income statements of varying length. What I'm trying to do is figure out a way to rank only the expenses.
The account names change from sheet to sheet, and the number of accounts always changes.
However, Expenses always START after a cell in the "A" column marked "OPERATING EXPENSES" and always ENDS after a cell in the "A" column marked "TOTAL OPERATING EXPENSES". However, I don't want to rank "TOTAL OPERATING EXPENSES" because it's the sum of all the indivicual expenses.
View 9 Replies
View Related
Mar 25, 2008
I know I can go about this using a pivot table, but I would rather not. However, if it really is the best solution, then I’ll go that route.
************************************************************************>Microsoft Excel - School Cases - Assigned.xls___Running: xl2002 XP : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutA1=ABCDEFGHIJ1Case NumberOpened DateClosed DateAccount NameCase ReasonStatusSpecific issueOpenClosedAge (Days)2243301/02/0801/02/08Vincennes UniversityDisbursingClosedDisbursing Agent Process Issue0103243801/02/0801/02/08The Culinary Institute of AmericaDisbursingClosed-0104244801/02/0801/02/08Southern Methodist UniversityCertificationClosed-0105245101/02/0801/04/08Regent UniversityProcessingClosed-0126246001/03/0801/03/08Vincennes UniversityDisbursingClosedReturned Funds0107246901/03/0801/04/08Pennsylvania State University (The)DisbursingClosed-0118247001/03/0801/14/08Vincennes UniversityCertificationClosedAccount Issue01119247701/03/0801/04/08Michigan State UniversityDisbursingClosedLoan Level-Change amount01110249701/04/0801/04/08Illinois Institute of Technology - Main CampusProcessingClosedRequest for loan status change01011249801/04/0801/04/08Southern Methodist UniversityCertificationClosedDidn't receive01012251101/04/0801/07/08Rutgers UniversityDisbursingClosedLoan-Level Change date01313251301/04/0801/04/08Capella UniversityDisbursingClosed-01014251401/04/0801/07/08Saint Johns UniversityDisbursingClosedLoan-Level Change date01315251501/04/0801/07/08Regent UniversityDisbursingClosedLoan-Level Change date01316253301/07/0801/07/08Purdue UniversityDisbursingClosedLoan Level Check Status01017254301/07/0801/15/08Saint Johns UniversityProcessingClosed-01818254701/07/0801/08/08Saint Johns UniversityProcessingClosedRequest for loan status change01119256401/07/0801/18/08Clark Atlanta UniversityProfileClosedReceived revision to profile011120258101/08/0801/08/08Saint Johns UniversityDisbursingClosedLoan Level-Change amount010Jan [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name boxPLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
What I basically need it to do is count the number of times a school is listed in column D then rank the top ten.
View 9 Replies
View Related
Jul 29, 2008
I recently made a formula of net sales contribution (sales per product category/total sales). For weeks 1.2008 to 30.2008. But I have several product categories. I would like near the value of the formula (not in another cell!) to insert a rank of these contributions. I d love to have the rank inside a parenthesis() near the percentage.
Here is the format
NET SALES CONTRIBUTION PER PRODUCT HIERARCHY 239.200740.200741.2007
COM RETAIL MEDIA0,03%0,73%0,22%
DTM STORAGE MEDIA0,00%0,06%0,00%
Of course I dont know how to do it.
View 9 Replies
View Related
Feb 4, 2009
Trying to figure out how to write a formula to rank values in B if the values in A are the same? I tried rank(if(A2:A17=A2,B2:B17))but this did not seem to work.
View 9 Replies
View Related
Mar 31, 2009
i rank some thing
stock 25
A B c D
rank style qty
1 st1 10 for d i need go to rank 1 first then qty 10
2 st2 5 then 2 then 3 till 25 (stock ) after it comes 0
5 st3 4
4 st4 3
3 st5 6
it can posible with rank and min formula
View 9 Replies
View Related
Aug 19, 2009
Which formula can I use to rank the people below.
Consider that the lower the value on attendance and cancellations is, the better this number will be.
In the other cells the highest the value, the better the number is.
NameAttendanceUtilizationProductivityQualityCancellationsCharles089.38%26.60NA0Nick587.69%56.921001Brian384.51%51.32800Joe080.71%36.151000
View 9 Replies
View Related
Dec 9, 2009
I have two columns of data - weights recorded during an angling competition. I currently have a rank set (in C) for the first column (A - pounds) to give a position for the highest weight recorded during the competition, the second column (B) records the ounces.
I need to be able to include the second column in the rank to cover the eventuality of two people recording the same number of pounds but different ounces.
View 9 Replies
View Related
May 10, 2005
I have a list of scores for people in one column and their groups listed in another. I want to rank their scores within their groups. how to do this? For example:
Score----Group----Rank by group
345--------A-----------1
367--------B-----------1
234--------A-----------2
123--------B-----------2
232--------A-----------3
View 7 Replies
View Related
