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

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

--
Regards
Frank Kabel
Frankfurt, Germany


Tang wrote:
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

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" wrote in message
...
Hi
not really sure what you're trying to do :-)
Could you give an example?

--
Regards
Frank Kabel
Frankfurt, Germany


Tang wrote:
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

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

--
Regards
Frank Kabel
Frankfurt, Germany


Tang wrote:
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" wrote in message
...
Hi
not really sure what you're trying to do :-)
Could you give an example?

--
Regards
Frank Kabel
Frankfurt, Germany


Tang wrote:
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