1. Home
  2. Compare Columns

Compare Columns

Select menu: Spread | Column | Compare

Use this to compare a column within the current spreadsheet with another column in the same or another spreadsheet. If any differences are found, you will be prompted with a warning message and a report is displayed in the Output window.

This dialog is useful for comparing two columns to see what differences there are between them. For example, you could compare a newly calculated column with a column obtained from Excel to detect any discrepancies in the formulae used within Excel.

  1. Open the spreadsheet(s) containing the columns you want to compare.
  2. From the menu select Spread | Column | Compare.


A dropdown list of columns in the current spreadsheet. The selected column will be used for the comparison.

Compare with

Lets you select a second spreadsheet and column to use in the comparison.

Ignore case when comparing text

When selected, comparisons between text in the two spreadsheets will be made ignoring the case of the characters. For example, ‘GENSTAT’ and ‘Genstat’ would be matched.

Tolerance for numerical comparisons

Specifies a tolerance to be used for numerical comparisons. When comparing two numerical items, if the absolute difference is less than this amount then this indicates a match between the items.

Abort comparison after finding N differences

This specifies a limit for the number of differences to be detected before aborting.

Action buttons

OK Compare the columns and close the dialog.
Cancel Close the dialog without further changes.

See also

Updated on March 20, 2019

Was this article helpful?