student

I'm not sure how to even phrase this question. I want to take a table of data and create rows for each entry. What I have: <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody> Name Algebra Biology Literature Student 1 1 4 3 Student 2 3 2...

in sheet 1 Range A2 To A6 contins Student name lke <colgroup><col></colgroup><tbody> STUDENT NAME Kalpesh Patel Amit Shah Vipul Rathod Jigar Patel Hitesh Doshi </tbody> i wish to this data add in sheet2 range A2. and every time data add in last blank row in sheet2. this is made...

I have a spreadsheet that I am trying to remove the first and last character when a student slides their card to check in to my office. when scanned it get this %11568?. I want to see 11568 and have vlookup look up the 11568 and put the student name in. This code is in B column, that reads...

Hello, In my tables of scores, I sometimes need to know how many times each student had scores that were below or above a particular score or within a certain range. (It's a growing table such that each week I add a new column at where column B is.) All weeks are indicated per column by the...

Hello, I was wondering if it were possible to fill a template that I have with individual student grades. I have the template that gets hand written but is it possible to enter a students last name and the grades auto fill into the template one at a time for review? also is it possible to input...

I need help on how to estimate the degree of freedom using Maximum Likelihood procedure for student t distribution. I am working with multivariate random variables.

I have a weather dataset of over 5000 entries. The entries have hourly recorded values for each day from 20th-Jan-2006 to 31st-Aug-2006. I have to separate every day by inserting three rows and in those rows i want three formulas which calculate avg, min, max for of the different parameters of...

Hello, I have a main folder which consists of many student folders and 1 Admin folder and this folder is moved to various locations on the network as needed. The student folders are originally named 1, 2, 3.... but when the class starts the folder names may be changed. Usually, the names...

Hello, Thanks in advance for your help. I am wondering if this is possible to do. Currently I have a master worksheet with many student names and information about the student. What I need to do is calculate the amount of commission we receive based off the tuition amount and other factors...

In few cells there are more than one criteria and when I generate pivot ; it counts as a single criteria . Pls refer to below snip : <colgroup><col><col><col><col><col></colgroup><tbody> Data : Criteria Student ID I like apple I like banana 2011 I like tiger 2012 I...

Hi all, hoping for some help... I've constructed a student mark book database with the following tables - <tbody> <tbody> TblStudents </tbody> TblResults TblAssessment StudentID ResultsID AssessmentID StudentEmail StudentID Title StudentName AssessmentID Date Tutor Mark TotalMarks...

Hello all, So I am just starting to venture into Excel VBA and I have been able to patch some things together with the help of this site, but I am now stumped as to how to resolve this one issue. I have a large report that has the workshop segments for a specific student registered that semester...

Hello, I have a table that consists of one student per row, and the scores for each student in the same row. I'm wondering if it's possible to make a line graph such that it displays scores in time for the student in the active row. That way, I can just make one graph and visualize any...

I have a excel table, which has a column each row will show number of student enrolled, and another column name of student attended. I want get the percentage of attendance based on enrollment. Problem I am having is Number of student enrolled repeated in each row. I have to take only once...

Been inactive for years and just logged back in using my 2004 Password! Looking for some assistance on this sheet my wife sent this morning. Should be easy for you guys on this board. Pretty sure it can be accomplished with those hairy INDEX/MATCH functions but they are Greek to me! We need...

Let us say i have list of students and score against each student. (Name of student may\may not repeat. i the list of top 3 students(Rank) and sum of scores against each student. Input: <tbody> A B 1 Shash 40 2 Yog 10 3 Yog 10 4 Avi 10 5 Ran 80 6 Shash 50 7 Raj 5 8 Raj 2...

Let us say i have list of students and score against each student. (Name of student may\may not repeat. i the list of top 3 students(Rank) and sum of scores against each student. Input: <tbody> A B 1 Shash 40 2 Yog 10 3 Yog 10 4 Avi 10 5 Ran 80 6 Shash 50 7 Raj 5 8 Raj 2...

Hello guys Column A has the marks obtained by the students whilst column B has the name of the students. Two student have scored the same highest mark. Now I want to know how can i find the name of the two students who have scored the same highest marks. When I use...

Hi All, I'm new to the forum in terms of posting but have searched around this forum for years for help with bits on Excel. I'm hoping for some help in terms of some formula if possible. I'm trying to create a timetable as such. I have a few days as sheets with different students names on and...

Hi, Middle school teacher here. I'd like to create a way to hit F9 to select a student at random from my classroom roster. Currently I am typing in and selecting the row of names and changing the formula every hour to just select a student at random, but it does repeat often. Is there a way...