Thanks Giuseppe for your quick reply. It doesn't seem to work. So e.g. there are 6 records, Name;Reference,Status;Date;Creator;NewReference;Type Test;Abc1;DONE;2022-09-09;Me;Null;INS Hello;Null;OPEN;2022-09-09;Me;Abc1;UPD Test;Abc2;DONE;2022-09-09;Me;Null;INS Hello;Null;OPEN;2022-09-09;Me;Abc2;UPD Test;Abc3;DONE;2022-09-09;Me;Null;INS Hello;Abc5;OPEN;2022-09-09;Me;Abc4;UPD So in above example, I would like to find records where reference with status DONE is not found in any other record under field New Reference with status OPEN. In abov example, abc1 and abc2 finds matched record but Abc3 &Abc5 doesn't find. many Thanks
... View more