I have two coloums (A&D) with each contains about 1000 names.

I would like to identify which names are new in coloum D compared to coloum A.

Does anyone have a suggestion to which formula is most appropriate to use?

Please let me know if you need aditional information