Allocations of currency notes

Hi,
Can anyone help me in solving my following problem.

I have few currency notes of different denominations totalling to $4470. I now want to distribute these notes under different lots of $:
150
200
200
220
260
340
440
470
770
1420

The notes I have are of following denominations:
Value Notes
$1000 1
$200 4
$100 19
$50 7
$20 18
$10 6

Is there any functions that I can use to allocate this automatically.

Any hints would be highly appreciated.

Thanks

Maybe like this:

Please Login or Register  to view this content.

The formula in C3 and copied down is =MIN(B3, INT( ($A$1 - SUM(D$2:D2) ) / A3) )

And in D3, =A3*C3

Thanks. That was amazing logic.

You're welcome