students

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 everyone, I'm new to this forum and the world of excel. Appreciate the all the help in advance. Thank you so much! I am stuck with a work problem to automate a recommendation system for matching tutor recommendations to students. (students will choose from a list of recommended tutors)...

I have a data in Sheet1 with Coloum A1 Name: Class X then A2,A3,A4 are the names of students in Class X and Column B1 Name: Class IX and then B2, B3, B4 are the names of students in Class IX and then Coloum C1 name: Class VIII and then C2,C3,C4 are the names of students in Class VIII. Now in...

Hi I am hoping that someone can please help me. Our schools spends hours every year calculating how many students should go in each class. We are given teachers on the ratio of students to teachers. Unfortunately, the students never fall evenly in the classes so we have to put some students from...

Does anyone know if I can use a QR code with an Excel document? I am wanting to use the =now() as a sign in/ sign out for my classroom and allow the students to scan the QR code with their phones. Does anyone have any ideas?

Hi All, I'm stuck with the answer on this one, I have a userform with 2 ListBoxes, Listbox1 is filled with 9 unique values. These 9 values are school programs. I have the user form submitting data on whether students are enrolled in any of these classes. It posts a TRUE of FALSE in one of...

I'm a phys ed teacher and recently I posted up a workout log on Microsoft Teams for my students to download, fill out and return to me electronically. Since Teams is still kind of glitchy and not all students know how to access it as easily as a google spreadsheet, I was trying to come up with a...

Hello, I have a worksheet to mark the student exams. The final mark is a formula and I want to hide the number value. However, when I click on it or select it, I want it to show. Since I want to show the students this file on my computer, however, I don't want them to see other students marks...

I have 40 students name. I need pick name only passed students in a column rankwise without any gap of row.

I am using 'small' / 'large' to give a rank order of students, such that students are ranked according to their test score, which works well. However, we can only award a limited number of grades to each class, therefore, once I have ranked ordered the class, (it does this dynamically), I need...

Hello Folks, I have 3 sheets in my WB, in the sheet2 i have the source data in table format from C column to H column. The first cell of all the columns has heading. In my sheet1 i used vlookup to pull data from the table in sheet2. My lookup value is in C column of sheet2. My requirement is...

Hi all! Our school require all students to have 23 credits to graduate. For the students to be in 9th grade, they must have less than 6 credits. To be in 10th grade they must have between 6 and 11.99 credits. To be in 11th grade, they must have between 12 and 16.99 credits. To be in 12th grade...

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, I'm looking for some help with getting userform label's caption to be the result of an index/match formula. Here's the setup: Two sheets, each with a table. Sheet1 has Table1, Sheet2 has Table2. Both tables are generally set up the same as far as column titles go. The userform is...

It’s been 10 years since I’ve last used Access so I’m one of those folks hoping an experienced user can quickly build me the basic database and I can take it from there. My students have to do practical experiments. For each student, I have to record whether..... <tbody> Comp 1 Comp 2 Comp 3...

Please can you show me how to quickly convert my data from 'before' to 'After'. Please be advised that the numbers will actually be students names and so it's not as simple as doing numbers 1 to whatever. Thanks in advance!!

Hi hopefully someone out there can help me. I have a Spreadsheet created/maintained by someone else with 2 data validation drop-downs in cells G2 and I2...one for Instructor Name and one for Student Name which loads the students scores. Because of the way the other person has the spreadsheet...

Hi all, I am having problems ranking a group of students by multiple criteria. The rank I am trying to do should be sorted by their overall result (column BK) and then by their name (column N) in case of ties. The rank generally works well, but at low percentage results students with no...

I'm trying to create a randomly generating maths drill file for students My file to date is NOT attached - I can't figure out how to do it. :eeek: I did search "attach file to post" but couldn't find how to do it To start with I want the students to be able to choose if the problems will be...

Hi I am having troubles trying to get a ranking formula to work for more than 1 student easily. I have managed to get it to work for 1 student fine but then looking for a way to copy the formula easily to the students underneath such as in the picture. Any help would be appreciated. For...