I need to remove the rows where Source=’SAP’ and the Reference Document Number does not match with any Doc Number in the sheet.
I have tried with filtering the two sources, taking unique doc number and ref doc num and doing a left outer join. But I am not getting the desired result. Could anyone guide me in the right direction. Thanks in advance!
