How to Match a neg with a pos. number

[ek26439]

Hello,

Ok.. here is my problem. If anyone can help that would be great. I
there any way that i can compare a group of positive numbers in on
column to a group of negative numbers in another column? I want to fin
the matching neg. number with the pos. number.

For Example:

-999 would match up to 999.

please let me know if this is possible.

thanks
eri

 

[Michael Malinsky]

=MATCH(-A1,B1:B10)

assuming your negative number was in A1 and you wanted to match it to an
array in B1-B10.

--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winnie the Pooh

 

[Peo Sjoblom]

Use

=MATCH(ABS(-999),ABS(A2:A100),0)

entered with ctrl + shift & enter

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[routeram]

Assuming column A and column B are your columns

=IF(ABS(a1)=ABS(a2),TRUE,FALSE)

should help. It will give you true if there is a match.

but this would match two +ve quantities too which I am not sure if yo
encounter. You can use sgn() to play with the signs in that case

 

[ek26439]

Thanks for the replys guys!

I have a group of negative numbers and a group of positive numbers. Th
neg. are in F2:F32 and the positive are in H2:H35 . What is the formul
to match the neg. in that column to the pos. in the other column.

thanks
eri