Excel code
 

I have a range of numbers and I want to get the possible combination of all
or some of them to add up to a specific amount can I do it on excel and is
there any formula helps me on this issue

Think of it as your typical checkbook reconciliation problem: you have
written 20 checks in various amounts, you call your bank's automated voice
response system and get your balance, so you know the total amount that has
been debited from your account, but you don't know which checks have cleared
and which ones haven't. How do you determine which subset of the 20 checks
add up to the amount that the bank has debited?€�

--
Thanks
Moises

Excel code
 

Look he

http://www.tushar-mehta.com/excel/te...ues/index.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Moises" wrote in message
...
I have a range of numbers and I want to get the possible combination of
all
or some of them to add up to a specific amount can I do it on excel and is
there any formula helps me on this issue

Think of it as your typical checkbook reconciliation problem: you have
written 20 checks in various amounts, you call your bank's automated voice
response system and get your balance, so you know the total amount that
has
been debited from your account, but you don't know which checks have
cleared
and which ones haven't. How do you determine which subset of the 20
checks
add up to the amount that the bank has debited?€�

--
Thanks
Moises

Excel code
 

Niek,
Many thanks, perfect.

--
Moises


"Niek Otten" wrote:

Look he

http://www.tushar-mehta.com/excel/te...ues/index.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Moises" wrote in message
...
I have a range of numbers and I want to get the possible combination of
all
or some of them to add up to a specific amount can I do it on excel and is
there any formula helps me on this issue

Think of it as your typical checkbook reconciliation problem: you have
written 20 checks in various amounts, you call your bank's automated voice
response system and get your balance, so you know the total amount that
has
been debited from your account, but you don't know which checks have
cleared
and which ones haven't. How do you determine which subset of the 20
checks
add up to the amount that the bank has debited?€�

--
Thanks
Moises