Find Missing Information

[Blessy Clara]

Hi All,

Thank you in advance,

I have a of sheet organizations and designations - NEW sheet

In this sheet some of the organizations may have only one designation or Combo of more than one for a given organization

I have another Sheet named Old - which contains information with designation as stated below

Designations Include
Principal
Deputy Principal
Assistant Principal
Associate Principal
Business Manager
Administration Manager

Requirement - Is I want to compare New with Old sheets and For any particular organization if any Designation is missing in New sheet then i need a note mentioned as Missing OLD sheet

Tables New

Albuera Street Primary School <tbody> </tbody>	Principal
Albuera Street Primary School <tbody> </tbody>	Business Manager
Burnie Primary School <tbody> </tbody>	Principal
Burnie Primary School <tbody> </tbody>	Deputy Principal
Burnie Primary School <tbody> </tbody>	Assistant Principal
Burnie Primary School <tbody> </tbody>	Administration Manager

<tbody>
</tbody>

Albuera Street Primary School is missing these designations

<tbody>
</tbody>

Deputy Principal
Assistant Principal
Associate Principal
Administration Manager


Sheet old

Albuera Street Primary <tbody> </tbody>	Principal
Albuera Street Primary <tbody> </tbody>	Deputy Principal	Missing
Albuera Street Primary <tbody> </tbody>	Business Manager
Albuera Street Primary <tbody> </tbody>	Administration Manager	Missing
Albuera Street Primary <tbody> </tbody>	Associate Principal	Missing

<tbody>
</tbody>

TO NOTE - OLD sheet may not have all designations, as stated but whatever is available for a particular org needs to be compared with the NEW SHEET

Any help will be greatly appreciated

 

[JonXL]

Never mind my previous question. I had to scroll.