Example: List of City Trees

In this example we will open a very large table of public trees in Wisconsin and sort it.

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: view->overAndUnderLayout

  • You can choose one or more key columns fromrulesButton->columnsChoose date in this example.

  • Still at 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 Session->TableCompareReport.

Last updated