I have two lists (columns) of data: a Full List of values, and an Exclusion List. I'd like a set of formulas that would create a third column Sorted List containing all the values in in the full list minus the values in the exclusion list. The attached spreadsheet shows what I am looking for.
Note that the Full List and Exclusion List may have blanks at the end.
The Full List MAY also have blanks within the data. I am not sure how much that complicates the formulas. So, I am looking at both solutions (one that can handle blanks within the data, and one that does not need to). Depending on the impact to the formulas, I can may choose one over the other and deal with the problem of blanks in a different way.
Helper columns are fine.
Thanks
ExcludeList.xlsx
Bookmarks