sum

[rramirez]

Hi,

Is there a way to find what numbers equal a sum in two seperate
columns? I am reconciling debits and credits and there are multiple
entries in debits that may equal an entry in credits or visa versa.

example:

debits credits
54 14
45 99
198 24


where 54 plus 45 equals 99. My report is more complex with approx. 250
entries.

Any help will be appriciated.

Thanks so much.

Robert

 

[Frank Kabel]

Hi
if you have that many numbers (>250) I doubt this is
feasible either in Excel or any other application. Too
many combinations to check