Auto set off for Bank Reconciliation

[Tang]

I am looking for an Excel function that can auto set off a list of number
(inlcude +ve and -ve) and generate a list of unmatched items.

The matching may include different numbers but can be matched off, eg -2, -3
and 5 will be set off.

The purpose is to make my preparation of bank reconciliation faster.


regards

 

[Frank Kabel]

Hi
not really sure what you're trying to do
Could you give an example?

 

[Tang]

i have a list of numbers:

100
120
110
130
50
750
-200
-100
-180
- 55

where

100 and -100 shall offset
130, 50, -180 shall offset

the result after the offset should be 110, 120, 750 and -55

 

[Frank Kabel]

Hi
and I assume you have many numbers >100?
In this case I doubt this is feasible in Excel (too many combinations
to check). Just mathcing equla numbers would be easy but also checking
sums of values would take too many times if you have many values