We have two Excel spreadsheets of city-planted trees. We will attempt to find days when the same species of tree was planted in both of our lists.
Our strategy for doing this will be to set date as a key column and then remove all of the other columns using the rules button.
We are going to choose a key column and also, choose some columns to ignore or delete.
First, make the view wider:
You can choose one or more key columns from
rulesButton->columnsChoose date in this example.
rulesButton->columns->editdo a delete of many unimportant columns. Don't worry, the original file will be unharmed. Keep deleting until all that remains is your Address[key] column and a few other columns of interest.
Note that Beyond Compare is in Read-Only mode for Microsoft files (Excel & word) and PDF files. We cannot alter the file nor save our work. We can export the report though! Use