Remove Duplicates from 2 columns then auto sort

[Dsnellin]

Hello,

I am trying to remove duplicates from 2 columns automatically without using a macro. I have a formula that does this but it replaces the duplicates with blank cells. How would I remove these blanks? I want this to automatically take place whenever the document is opened. I was thinking if I could automatically sort, the blanks would just get moved to the bottom but I am not sure how to do this. I have attached what I have done so far.

Thank you!

[NBVC]

See attached.

Instead of your Concatenate() helper formula, try this helper in C2:

=IF(COUNTIFS(A$2:A2,A2,B$2:B2,B2)=1,COUNT(C$1:C1)+1,"")

copied down

Then in D2 enter:

=IFERROR(INDEX(A:A,MATCH(ROWS($A$1:$A1),$C:$C,0)),"")

copied down as far as needed and to next column