I have a master list of orders in a spreadsheet.
Column A lists all orders. Column B lists a subset of all orders. If both lists were small, I could manually do this but I have hundreds of records to look through.
What is the best way to find values from Column A that do not exist in Column B, and place them in Column C?
Visually, I am looking to create a Column C like this:
Column A Column B Column C A1 A3 A1 A2 A5 A2 A3 A4 A4 A5
Note that I am not seeking to merely highlight unique values in Column A, but I am looking to copy those unique values into a new column (C).