| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming | |||
| do anybody have a sample code for executing excel macro from vb code?<eom | Excel Programming | |||
| stubborn Excel crash when editing code with code, one solution | Excel Programming | |||
| Excel XP VBA code to search all macro code in Excel module for specific search string criteria | Excel Programming | |||
| Excel XP VBA code to search all macro code in Excel module for specific search string criteria | Excel Programming | |||
Hybrid Mode
