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
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 400"]
<tbody>[TR]
[TD="class: xl69, width: 400"]Albuera Street Primary School[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Principal[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 400"]
<tbody>[TR]
[TD="class: xl69, width: 400"]Albuera Street Primary School[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Business Manager[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 400"]
<tbody>[TR]
[TD="class: xl71, width: 400"]Burnie Primary School[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Principal[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 400"]
<tbody>[TR]
[TD="class: xl71, width: 400"]Burnie Primary School[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Deputy Principal[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 400"]
<tbody>[TR]
[TD="class: xl71, width: 400"]Burnie Primary School[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Assistant Principal[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 400"]
<tbody>[TR]
[TD="class: xl71, width: 400"]Burnie Primary School[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Administration Manager[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 400"]
<tbody>[TR]
[TD="class: xl71, width: 400"]Albuera Street Primary School is missing these designations[/TD]
[/TR]
</tbody>[/TABLE]

Deputy Principal
Assistant Principal
Associate Principal
Administration Manager


Sheet old

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 400"]
<tbody>[TR]
[TD="class: xl71, width: 400"]Albuera Street Primary [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Principal[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 400"]
<tbody>[TR]
[TD="class: xl71, width: 400"]Albuera Street Primary [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Deputy Principal[/TD]
[TD]Missing[/TD]
[/TR]
[TR]
[TD][TABLE="width: 400"]
<tbody>[TR]
[TD="class: xl71, width: 400"]Albuera Street Primary [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Business Manager[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 400"]
<tbody>[TR]
[TD="class: xl71, width: 400"]Albuera Street Primary [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Administration Manager[/TD]
[TD]Missing[/TD]
[/TR]
[TR]
[TD][TABLE="width: 400"]
<tbody>[TR]
[TD="class: xl71, width: 400"]Albuera Street Primary [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Associate Principal[/TD]
[TD]Missing[/TD]
[/TR]
</tbody>[/TABLE]


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.