I have 2 separate workbooks in Excell 97 format.
The first one has a list of values in the A Column. For simplicity, let's say there are 50 different values.
In worksheet 2, I have a sub-list of about 10 values. These 10 values can all be found in the first spreadsheet.
The small list are values that I need to delete out of the first list. How can I compare these two lists, and find which values are present in both lists? Is there a Union function or something that will do it?