array for highest value

[oracle_coorgi]

hi
there are three sheets one bank_notes second notes and last value
i need an array function which can calcualte the notes aviavable on banks_notes
which i enter in the value sheet the put then in notes sheet

eg:
1.if i enter 150 in value sheet value cell
i should GET from the bank_notes sheet CELL avaiable_NOTES WITH THE HIGHEST facevaulei should get one 100 note and one 50 note in notes sheet
2. if i enter 255 in value sheet value cell
i should GET from the bank_notes sheet CELL avaiable_NOTES WITH THE HIGHEST facevaule
i should get one 200 note and one 50 note and one 5 note in notes sheet
3.so on

[antoka05]

See the attached file... I hope it's what you need.

Regards,
Antonio

[oracle_coorgi]

hi
thanxs a lot in one shot gr8

one more issue in this
if for eg:
250 one 200 and one 50
it should delete from bank_notes cell AVAILABLE_NOTES
18 to 17 and one 50 AVAILABLE_NOTES 25 to 24
because AVAILABLE_NOTES will decrease as the notes are given

thanxs once agin

[antoka05]

See attached file... I hope it's ok for you.

I added decrease available notes and also control on it... it doesn't take facevalues if corresponding available notes are not greatest than zero.

Regards,
Antonio

[oracle_coorgi]

simple gr8

thank u soooooooooo much