I work for a company that tracks employees' hours. Right now we are having an issue with voided hours/checks. The payroll I received has their original check with amounts and hours on it, then shows it being voided (just the negative side of the same numbers) and then the reissued check (most of the time, the same numbers as the original check). I need to remove the original and the voided while still keeping the reissued check listed. I am having issues with using the 'remove duplicates' because of the reissued check being the same number as the original. Any ideas or formulas for me?

Thanks in advance.