Purple Grapes 33 - BOQ Compare

Choose your two files

File 1: Original BOQ

Drop an .xlsx file here, or select one Excel workbook (.xlsx)

Worksheet

File 2: Revised BOQ

Drop an .xlsx file here, or select one Excel workbook (.xlsx)

Worksheet

Set how to compare

Comparison mode Original VBA mode Matches your Excel macro. A row is a match if its combination appears anywhere in the other file, however many times. Duplicate-aware mode Counts repeats. If File 1 has a combination three times and File 2 has it twice, one row in File 1 is unmatched.

Comparison columns

Column letters, in order. A range such as A:C also works. The first column decides where the data ends and which blank rows are skipped.

First data row

Row 1 is treated as the header.

Results

Comparison summary
Rows	Original BOQ (File 1)	Revised BOQ (File 2)

Export formulas as values only

The workbook has four sheets: Summary, Original BOQ, Revised BOQ and Differences. Your uploaded files are not changed.

Preview rows