How to determine the rows, which only occur in one spreadsheet - Excel added rows - Excel deleted rows - Excel removed rows - Excel new rows - Excel added lines - Excel deleted lines - Excel removed lines

Tutorial

How to determine the rows which only occur on one spreadsheet?

The following example shows how to determine the rows which only occur on one spreadsheet.

Open the two Excel files and verify that both spreadsheets contain a database structure. The columns which contain identical data must contain identical headings. This is important as Synkronizer can only link columns with the same captions (see user manual chapter 2.1.2).

In our example we want to compare two customer files (Customers 2005-10-31.xls, Customers 2005-11-30.xls).

Start Synkronizer and open the two files.

Mark the spreadsheets as databases.

Click the section "Database" and select as primary key the column which contains the identification No. In our example it is the column "Customer No.".

Pick the tab "Display" and select all elements of the list box except the entry "Unmatched rows". In that case only the deleted and added rows will be visible. If the other rows should be deleted, select "DELETE identical data instead of HIDING it?"

Select the tab "Compare" and select the action "Highlighter".

Press the "Start" button. The rows are displayed, which occur on only one spreadsheet.