I could come up with a coding (Macro) solution. Would need to know if the
two values to be compared are in the same column (as in duplicate entries in
2 or more rows) or if there are 2 cells on a single row to be compared.

Are the entries to be compared on one worksheet or a group on one worksheet
to be compared with a group on a second worksheet. From your write up, it
looks like there's a point where everything is on a single worksheet when you
start looking for ones to delete.

"mrharpo2u" wrote:

i have two work sheets in one spreadsheet. they are from different systems
one feed to the second to create refunds. I have been forced to cut and
paste both sheets to a new worksheet and then sort by amount and then delete
like amounts to find refunds not carried over to the other system. Is there
an easier way to match and then delete matching amounts, therefore saving me
valuable time.