Question

notes on compliments of MS EXAL​

Answer 1

Answer:

Is there a way to find the complement of one set of data in another within excel? looking for a function that will take as inputs the contents of separate cells and return the complement of one set of these contents in another.

For example if I have array A:{A,B,C,D} and Array B:{A,B,C} I am looking for a quick way to take these inputs and get {D} (the complement of B in A) in return. Basically I am comparing one list of info against another for completeness.