school

I have excel sheet which contains the data as (dummy data). <tbody> Code School Employee 123 AAB xyz 123 AAB MNO 123 AAB ANO 323 CCB Jam 323 CCB Yoi </tbody> On the second sheet I have same columns. by using vlookup I got the results of School. So i want to get the drop list in...

<tbody> SNO NAME CONTACT 1 PUBLIC SCHOOL 1 9855666 930000 2 PUB SCHOOL 2 82899633 </tbody>

I have 3 columns of data, within each column each data piece will be unique, but will be duplicated across 1 or both of the other columns. for notes a single cell will contain a value that looks like this "511VSB643770000201" But for illustration lets pretend that each cell contains a...

Hello! I am a teacher who uses Moodle (an online LMS - Learning Management System). I have two Excel files that use macros to make Moodle XML files for importing questions into Moodle. I combined the two files into one, with various worksheets for either Short Answer creation, Multiple Choice...

Hello All, how can I convert multi rows data into single row using power query.. My above column must look like the below comlumn.. Thanks.. <tbody> Driver Name Driver ID Bus Number School ID School Name Timing David 1005 F5002 A123 Helen Model School 7:15 David 1005 F5002 A300 Stuart High...

Hi all I am fairly new to VBA and trying to move rows if a certain word is found in a cell in a row of text. So ie: Column E has a title of Known As - this column then has names of premises such as "Made up name school". I need a way of moving every row to another sheet when this "school"...

I'm having trouble finding a solution to this problem. Basically, I build a bunch of workbooks for colleges and I like to have the colors match the school colors as much as I can. I can make themes for each school, but eventually I lock off a bunch of formatting functionality, so the end result...

Hi all. Just to say, before I seek your advice - I am completely self-taught on Excel and can handle the basic formulas etc, so please excuse me, if I'm not using the most appropriate process or formulas in devising my workbooks etc. I devised a spreadsheet for my wife, who works with...

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, I have this formula, but it is not working. Any advice is welcome! =SUMPRODUCT((database!$B$2:$B$<wbr style="font-family: arial, sans-serif; font-size: 12.800000190734863px;">7=$B$1)*(database!$P$2:$P$7=<wbr style="font-family: arial, sans-serif; font-size...

Is anyone can share me school examination Room Sitting plan. In My school there are 900 students. Two sections in all Classes. 20 Rooms are the. Sitting plan of a room will be like this. In one Room 1. 4 rows 2. Im one row 5 benchers are there. 3. In one bench two students will sit of different...

Start date in a2=4/1/2015 Return date in b2=10/31/2015. School Ends 5/31/2015 and Begins 9/1/2015; Therefore, this student missed between 17 to 20 weeks of school. I think it’s a matter of finding out the length of weeks between the start date and return date; then subtracting any weeks in the...

Hi all I am happy to give formula's a go, but I am out of my depth with this one. In a nutshell I would like a formula that would tell me, if somebody based on their date of birth is statutory school age. The requirements for statutory school are detailed below. If anybody is up for the...

Hi - I'm a Gifted Education teacher that takes small groups of students on a ton of different field trips throughout the school year. Not all of the kids attend all of the trips. At the end of the year, I'd like to create a list for each individual student of the field trips they attended...

Good Day all. Since schools is about to start, I thought that I should create a spreadsheet in order to schedule my teachers in the various yard duties throughout the day. What I would like to accomplish is schedule about 25 teachers to cover yard duties. The various duties are as follows: Bus...

I am attempting to create an IF or IF(AND formula that I can use to display the letter grade I earned based off of a certain percentage criteria. I have had trouble creating this formula myself. Hopefully someone can help. Please refer to my notes below to examine the criteria. Let me know if...

I use excel as my school mark book. This involves needing to convert grades (letters) into numbers and vice versa. I am able to use a vlookup table for the majority of this. However I have found an anomoly when trying to include grades at A-star (A*). I have included a table like this to show...

I'm needing to compile data based on student performance over 3 terms of the school year. The example file is stored at: http://dl.dropbox.com/u/5892902/example.xlsx Each term, my school creates a list all the students who obtain either Honour Roll (A or B) and Effort (E) Standing. It uses a...

Hi, I am trying to make a database for a school, to make an automated roster. There are four entities: Teachers: t1-Jones, t2-Smith, t3-Paddington, t4-..... Classes: c1-YearOne, c2-YearTwo, c3-YearThree, c4-..... Subjects: s1-English, s2-Math, s3-Grammar, s4-..... Hours per class per teacher...

Hello all, I have been struggling with a problem to which I do not seem to have an answer. Any help woould be greatly appreciated. I have created a spreadsheet to calculate the average mark that I would give my students taking in consideration various tools for evaluation that I use in class...