I have a problem where I am trying to identify certain figures from column A that total column b.

for example.

If i have say 20 figures as dollar amounts between $1.50 and $3.50 and I want to find the possible combinations of these figures that total say $12.50.

I need something that highlights the amounts that make up the total.



Does anyone have a macro that can do this?
Or any ideas?

Thanks guys.