science

Can anyone help me with this. One of my sheets has info on student ID and the class they were in last year. The new sheet has the student id and the class they are enrolled in this year. If they both don't match it should say bad. Sheet two should look like the table below. The range is...

As the title says really. I have a table which looks something like: <tbody> Ethnicity English Maths Science Triple Science Art Drama Citizenship Geography 1 Black Caribbean Y Y Y Y Y 2 Afghan Y Y Y Y Y 3 Afghan Y Y Y Y Y 4 Indian Y Y Y Y Y Y Y </tbody> So I want a unique...

Another day another plea for help :) I have a spreadsheet with 255,398 rows. Each student has anything between 5 to a 1000 rows, however, not each row has the student's details. So the table (in a very simplified form) looks something like this <tbody> Surname Forename UPN Achievement...

Hi everyone, there is a large amount of orders I receive everyday which Needed to be recorded into the master file, in contains of different category of course types. Is there a way that could look up the regular courses and copy the whole row down, and whenever new courses are registered...

we have six subject marks internal and external need formula to sum best of five subject external marks and sum of internal marks which correlate with best of five external marks External Marks ENGLISH HINDI MATHEMATICS SCIENCE SOCIAL SCIENCE COMPUTER SCIENCE (Internal marks )ENGLISH HINDI...

I have a table that looks like this: <tbody> Teacher Class Mark Smith English Mark Smith Math David Park Science David Park History </tbody> I currently have a VBA solution (at the bottom) that combines teachers to one row, and lists their classes in the next, separated by commas...

Hello I have a table similar to the one below: <tbody> English Teacher English Teacher Target English Teacher Assessment Maths Teacher Maths Teacher Target Maths Teacher Assessment Science Teacher Science Teacher Target Science Teacher Assessment a b b- e d d i s s+ b d b f s d+ j m m-...

Hello all, I have two excel work books namely 'Schools.xlsx' and 'colleges.xlsx'. Both excels workbooks have 4 worksheets namely 'Science', 'Maths', 'English' and 'General'. I have to copy the entire contents in Worksheet 'Science' in 'Schools.xlsx' and paste it in Worksheet 'Science' in...

I am trying to generate a printout of a simple Sine curve where the scale is exact so that students may be able to use rulers to accurately measure attributes like Amplitude, Frequency, Period, Phase and Offset. My currently oversimplified table is Time, Sine 0 ,=2*Sin(Time) .2 .4 .6 ...

Greetings Mr. Excel. Thanks in advance for your assistance! I am running Microsoft Office Professional Plus 2007 on a Windows XP pro service pack 3 federal machine. I have a long scientific formula having to do with soil moisture that was given to me by a colleague. In it, he describes the...