Compare/match positve number against negative number?
 

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

--
Kobayash
-----------------------------------------------------------------------
Kobayashi's Profile: http://www.excelforum.com/member.php...info&userid=87
View this thread: http://www.excelforum.com/showthread.php?threadid=31488

Compare/match positve number against negative number?
 

Looks like you answered your own question about using ABS

--
Don Guillett
SalesAid Software

"Kobayashi" wrote in message
...

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

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

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

Thanks,

Adrian


--
Kobayashi
------------------------------------------------------------------------
Kobayashi's Profile:
http://www.excelforum.com/member.php...nfo&userid=871
View this thread: http://www.excelforum.com/showthread...hreadid=314883