I do invoicing for a large trucking company.
Each invoice contains hundreds of ticket numbers that
can belong to any of 40 trucks.
In an attempt to avoid errors, I have created a checking sheet, where
each truck has all of its tickets entered, complete with total $
and ticket #.
I am trying to create a formula that will search through my invoices
and verify that the combination of ticket & truck match up
to the totals that are displayed on both invoice and check sheet.
I have created formulas that tell me if a complete invoice does
not balance, but I am looking for a formula that will actually
show me WHICH ticket does not balance.