Removing Duplicate Values and Their Inverse

[redloh]

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.

[bmouse]

Is it possible for you to post an example file?

[alikazmi]

I am totally confused to read your post, Always remember it in Excel, If you have any Question related to excel, please attached a Sample file, where we can see what you want to do, additionally if you think you have useful Data in numeric form, than use random Data.