Compare/match positve number against negative number?

[Kobayashi]

I have one worksheet that contains multiple fields. I wish to compar
all of the rows in the sheet with each other and, when 4 of the field
match, copy the matching rows to another sheet/workbook.

Now, this I can manage but, one of the fields will contain a positiv
numbers, say 100 and another field will conatin a negative; -100, s
they aren't actually a match. It is these that I want to capture as
'match', although the other 3 fields will also have to be a prope
match.

Any ideas where to start? I guess the abs() function might come int
this somewhere but I just need a pointer in the right direction? I'
then happy to go off and (try to) work the code out.

Thanks,

Adria

 

[Don Guillett]

Looks like you answered your own question about using ABS