Are there any people good with excel about

[Wereongunoil]

Are there any people who are knowledgeable about excel. I know very little but am struggling with this problem

I have an excel sheet showing scores from tests

The master sheet has students listed in alphabetical order and the subject sheets has them listed in score order.

What formula do I use to move the data from the subject sheets to the master sheet and make sure it's attached to the correct person

Eg

Master sheet lists

Fred
Joe
Bob
Bert
Harry

Then the maths sheet has the order

Joe
Bob
Fred
Harry
Bert

The English sheet order is

Bert
Harry
Joe
Bob
Fred

Thank you

If it's exactly the same students on all three sheets, can't you just sort them all by student name alphabetically, then copy the maths and English scores over?

Go to the toolbar at the top and choose data then sort. Presumably your columns have titles (headers)? Tick the box which states this and add name and score in the boxes to sort the data by. This will put the names in order followed by the score each has attained.

Difficult to describe here without excel open in front of me - you might find it easier to Google "how to sort data in excel" and follow visual instructions.

Yes, you could sort the sheets so all the names apply alphabetically.

If this is impractical, otherwise you want the IF function

Click on formulas, logical, IF

You could do a Vlookup on the names to get the results. So have column for name, maths, English. In the maths column do the lookup by name and searg the maths sheet returning the value for the score.

You need a vlookup which finds the name and then brings back the score but it might take a while to add it if you aren't familiar.

Depending on the number of students and if the names are all in the same format sorting alphabetically and copying across might work. But do some spot checks after you have done it.

For various reasons I won't be able to sort every sheet alphabetically

I'll have a play with vlookup, thank you