Remove Duplicates with Criteria

Hi All,

I am having trouble figuring out how to filter my report of Electronic Transactions (Credit/Debit/EBT etc...)
The normal message that comes accross is "Approved" but during an Network Outage we have a message of "Error"
The fields I have are Store/Date/Time/Amount/Account (Last 4 Digits of the Card).

I want to filter out a line with "Error" if there was a Store/Date/Amount/Account which matches an "Approved" message

The ultimate goal is for this report to tell me the actual amount lost (with the exception of the customer paying cash).

Any help would be appreciated. Thank You!

How about concatenating the store,date,amount and account on each line to produce a key, and then match observations by their key?