Hi all excel experts,

I have data in this format and i want to pay cash to 300 casual workers so i need the denomination breakdown:

Name Date: Amount

A 31-05-13 120,550

B 30-06-13 65,700

C 31-05-13 1,250,700

On cell A5 is date criteria 31-05-13

On cell B6 to B10 I fill in the denomination needed and B6:B10 the formula is needed

10,000 =DENOMINATION((B2:B4=A5)*(B2:B4,B6)), how many 10,000s are needed in May 31st

5,000 =DENOMINATION((B2:B4=A5)*(B2:B4,B7)), how many 5,000s are needed in May 31st

2,000 =DENOMINATION((B2:B4=A5)*(B2:B4,B8)), how many 2,000s are needed in May 31st

1,000 =DENOMINATION((B2:4=A5)*(B2:B4,B9)), how many 1,000s are needed in May 31st

500 =DENOMINATION((A2:A4=A5)*(B2:B4,B10)), how many 500s are needed in May 31st

Thank you in advance!

Gauss.