Identifying values that don't appear in both columns - PLEASE HELP :-(

[louise_atherton]

Please help

I'm trying and failing to be able to highlight which values don't feature in 2 columns. 

I have a table, it contains registrations for each site and these have their own unique ID.  

I than have another table, which shows when a check has been completed on a registration.  The Site and Reg will match that of table 1 but they will have different ID's as are on different forms. 

What I want to do is to be able to merge the 2 data sets together to give me a new table to flag the registrations that have not been checked for that day. I don't need that table to feature an ID. 

Can anyone else me?  I can only do this via expressions as we have a diluted version available to us so am limited to this option only. 

Many thanks in advance to taking the time to read through and hopefully one of you will be able to shed some wisdom my way and help resolve. 

Thanks in advance

Louise 

[MayilVahanan]

Hi Louise,

Hope you have unique site per Reg. In that case, try like below

=Only({<Reg=E(Reg), Date=>}Site)

Screenshot:

[louise_atherton]

I have multiple registrations per site and also the 'Reg' on table 1 is a different dataset to the 'Reg' on table 2 as they are called something slightly different so its actually more like 'Reg Database' and 'Reg Checked' though the values contained within should be the same.  Hope that makes sense?