Excel / comparing data

Closed
malwina_college Posts 1 Registration date Tuesday 23 February 2016 Status Member Last seen 24 February 2016 - 24 Feb 2016 à 03:51
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 25 Feb 2016 à 11:38
Hello,

my name is Malwina.
I would very much appreciate your help, please.
I was trying to compare the spreadsheets but really have no idea how to go about it.

I have 2 spreadsheets with students data (ID is a unique number)
sheet1
Course Code
Course Name
Level
Year
ID
Forename
Surname
DOB
Placement name
Required hours (RH)


sheet2 (Master)
Course Code
Course Name
Level
Year
ID
Forename
Surname
DOB
Planned hours (PH)

The problem is that Master sheet consists of more info - list of all students as well as the required hours RH and planned hours PH vary, when the planned hours are correct.
I am trying to get the combined list of students consisting of ID, forename, surname , course code and placement name with the column whether there is any difference between required hours and planned hours.

result
sheet 3
Course Code
Course Name
Level
Year
ID
Forename
Surname
difference in hours (PH minus RH)
placement name

thank you very much
Malwina

1 response

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
25 Feb 2016 à 11:38
Hi Malwina,

The headers provided are column headers right?

So basicly you want to copy Master sheet data to Sheet3. Look the ID's up on sheet1 and when found copy their Placement name and determine the difference in hours. Is this what you had in mind?

Best regards,
Trowa