student

I have a spreadsheet that looks like this: <tbody> Student Course John Smith English;Math;Science;History Jane Smith Math;History;Art </tbody> I would like to replace all semicolons with line breaks if possible, so that it would appear like this: <tbody> Student Course John Smith...

<small style="box-sizing: border-box; -webkit-font-smoothing: antialiased; font-size: 11.04px; text-transform: uppercase; display: block; color: rgb(105, 109, 111); font-family: "Helvetica Neue", roboto, Arial, sans-serif; background-color: rgb(238, 242, 244); outline: none !important...

Hi All - I am looking for some help with a problem for work (assistant principal). What I would like to have done is to take the following information (Student Name, Behavior, Academics, Gender) and then generate a certain number of class lists that represent approximately equal distribution...

I have this spreadsheet I pieced together, and I've got it working pretty well. The one thing I can't seem to figure out through all the reading I've done is how to use the Sheet Codenames in VBA to do what this currently does IF a teacher accidentally moves sheets out of order. It's happened...

In Sheet 1 below are student and their subjects result and total. Sheet 2 has their total per term. How can I copy Column F and transpose it to Sheet 2 and still has the result and the formatting with every update from retest taken by student? Student may retake the test and...

hii friends, I'm new in excel vba,i just want to make a student database in excel userform, and there is a column student id, which is the alphanumeric serial like "ICE/ANG/1001".every time when i open the userform to enter a new student database the id text box goes to auto fillup or generate...

Hello Excel gosu's, I have a pickle with an excel formula, and I can't seem to find an answer anywhere. My data looks vaguely like the data below <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> student class marks A A 10 B A 10 A B...

Hello, I want an excel program that will extract the contents (values of results) from the sheet (HND 1 FIRST) and display it as a sample of the first student (ABIODUN RACHAEL). Out of the labels (Name, Matric No, Department, Programme, Session), the matric no will be the variable to use to...

Hi All, Extremely new to the forum and VBA. I was wondering if anyone can help me out? I am looking for a VBA Code that can run through a data dump and filter for the Top ten highest variations and paste the correct data into the related tables. I also understand this could be done in Pivot...

Hello, I have a search functionality in an Excel workbook which searches according to a cell value from worksheet, "Search students", searches within worksheet, "2017-18 student list", then copies and pastes the find results in a third worksheet, "Search Results". My problem concerns the...

For cleaning up student testing data that will be imported elsewhere, I would like to set up a macro and/or formula(s) to: - find if a student tested more than once during any month in a year - if so, find the higher __ score (there are multiple values, so let's say highest TOTAL score, as I'm...

I have a spreadsheet in excel 2016 that contains the names of all the students in my school. The sheet has the students’ names, student id (which is unique for each student). One of the columns in the spreadsheet is ELL (Column I) which refers to English Language Learner. If there is a “Yes” in...

I'm trying to figure out how the set a "SUP", "SAT", and/or "UNSAT" rating in a column for grading purposes. **For Instance** Column A (Initial Test) a student scored a 50% Column B (Restest) the student scored an 80% The column in question would be Column C (Final Rating) - How do I set up a...

My excel sheets has the schedule of all the students in my school. The schedule has the following fields. Please see the sample for one student below: <tbody> A B C D E G H I J K L M N O P 1 Counselor Grade Ident Student Name Period Course Title Teacher Room Ident Student Name Period Course...

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...

Hi again I'm still exploring data validation options. And need to know if something is possible. I have a list of student names in sheet 1, column A. The range is named "Students" There are various assignment types listed in row 1. For example, B1 contains "Discourse", C1 "Demonstration" & D1...

I have a workbook and a pivot table. On the pivot table I have ROWS: Ethnicity and Behavior Response Behavior response includes items like Restraint and Suclusion On VALUES I have a count of Student ID. So, naturally it is counting the number of student IDs in each Ethnicity in each Behavior...

Hi all, I'm something of an Excel neophyte, and while I've mostly been able to cobble together some clunky algorithms to do what I need, I'm stuck on one point which has a few more variables than I can sort through, and have come up dry after scouring the internet. Basically, I'm preparing a...

Hi, this is my first post, thank you in advance for any help you can give. I have a spreadsheet with multiple sheets (1 per student) Each student has the following 2 identical columns on their sheet Column D = Time added or time minus (added is when they buy, minus is when they use) Column...