I have two lists that should contain the same values. In Excel, they are in
two columns. In the third column, I want to put the values that are in List A
but not in List B. In the fourth column, I want to put the values that are in
List B but not in List A.

List A is from A1 : A501

List B is from B1 : B458

Can this be done in Excel?