Need to see if there is a formula for this
For example:
I have 2 ranges (Journal entries)
-1
-2
-3
-4
10
is there a function I can use to look through the negative values and find all of the values that equal 10?
Main problem is I am searching for values that do not net to zero when paired with the positive value.
For example:
I have 2 ranges (Journal entries)
-1
-2
-3
-4
10
is there a function I can use to look through the negative values and find all of the values that equal 10?
Main problem is I am searching for values that do not net to zero when paired with the positive value.
