Formula to display blank if a cell is blank and to display text if value does not match

Im trying to compare 2 masterlist and apply the changes to a company software
need help to identify which is to be added and which is to be remove
i was able to get to the part where it displays add and remove my delimma is when there is a blank on either cells under sups and oms

Attached is a sample
Please assume some cells under sups and managers are empty for the last part

Any help is much appreciated

you add an extra test to see if A3 and A3 have an argument in it. if the count is not 2 then one of them is blank and cell needs to be blank..
you can use an OR() function to test both criteria at once.

Formula:

=IF(OR(A3=D3,COUNTA(A3,D3)<>2),"","Remove")

It works with Letters and Numbers
The value in A3 and D3 are FirstName.LastName
their unique Domain ID
The formula provided works with the sample provided Sup 1 OM 1 but not with FirstName.LastName

Thanks for looking into it Sir