Hello,

I can normally find my way around excel, so this is my first time posting here. I have had a little look around the internet and also around this site. I can not find a solution to my problem.

I have a dozen or so cells containing numbers. I need to know if there is a way to calculate all the possible combination and tell me which one will give me the closest total without going over the limit.

I suppose the best way to explain it is going bust in the card game 21.

Thanks very much guys, any help is greatly appreciated as this is driving me a bit crazy.

Thanks