▥ Small Business StackEquipment List Revision Checker ↗
Free practical guide · Excel / CSV

How to compare two revised equipment lists by Asset ID

Find added, removed and changed equipment before updating a repair or maintenance estimate—even when rows have been rearranged.

Example data is fictional. This guide covers structured spreadsheets, not scanned PDFs or drawings.

Why comparing row 10 to row 10 can fail

A client sends a revised equipment list after you have prepared an estimate. If the new list contains extra assets, missing assets or a different sort order, comparing the same row numbers does not tell you whether an individual piece of equipment changed.

The safer approach is to match records using a stable identifier such as Asset ID, Equipment ID or a reliable serial number. Compare each matched record after checking that the IDs are genuinely unique.

Worked example

Original list

Asset IDEquipmentEstimated repair cost
A-001Pump€140
A-002Valve€80
A-003Motor€210

Revised list

Asset IDEquipmentEstimated repair cost
A-003Motor€210
A-001Pump€160
A-004Fan€120

Differences to review

ResultAsset IDWhat changed?
ChangedA-001Repair cost €140 → €160
RemovedA-002Valve missing from revised list
AddedA-004Fan appears in revised list

Five checks to perform in Excel

  1. Preserve equipment IDs as text. Values such as 0012 and 12 are not necessarily the same asset. During CSV import, avoid automatic conversion of IDs into numbers.
  2. Check blank and duplicate IDs first. If the IDs are in column A, a duplicate check can use:
    =COUNTIF($A$2:$A$1000,A2)>1
    Review any row marked TRUE. Blank IDs cannot be reliably matched. Do this separately in both versions.
  3. Find items removed from the new list. On the original sheet, with old IDs in column A, use:
    =IF(COUNTIF(Revised!$A:$A,A2)=0,"Removed","Present")
    This assumes the new worksheet is named Revised and its IDs are in column A.
  4. Find newly added items. On the revised sheet, use:
    =IF(COUNTIF(Original!$A:$A,A2)=0,"Added","Existing")
    This assumes the original worksheet is named Original.
  5. Compare important fields on matched IDs. For example, retrieve an old repair-cost value into the revised sheet:
    =XLOOKUP(A2,Original!$A:$A,Original!$C:$C,"Not found",0)
    Compare that result with the new cost in column C. Use the same approach for quantity, description, status or any other fields that matter to the estimate.
Before using these formulas: Confirm that each ID is unique, the sheet names are correct and the source values are valid. Formulas may need different argument separators depending on your Excel locale. Do not treat a blank price or a deleted row as an approved estimate change.

What if there are hundreds or thousands of rows?

Excel Power Query can merge tables by Asset ID and help find unmatched records using anti joins. It can also be used to compare attributes after a full or left outer join. This takes setup and still requires careful treatment of duplicate or missing keys.

Whichever method you use, preserve copies of the originals and produce a review report before changing an estimate. An added or missing equipment line might reflect scope changes, data errors or renumbering—it is not automatically a price change.

Would a simpler revision report be useful?

We are exploring Equipment List Revision Checker, a proposed one-time-purchase tool for comparing structured equipment spreadsheets by Asset ID and exporting a readable Excel report.

Status: Coming Soon — not available for purchase. Planned price: €29. No working file comparison is available on the concept page.

See the proposed reportTake the 1-minute survey ↗

Your feedback will help us decide whether to build it. The survey is optional; you do not need to upload business documents.