Choose numbers from a list to give a total

Carty

Board Regular
Joined
Mar 3, 2009
Messages
76
Hi. Can you give Excel a target to get to when picking from a list of numbers? e.g. if the list is 1,2,3,4,5,6,7,8,9 and the target set is 22 can you get Excel to pick a selection of numbers to give you 22 - 2,5,7 & 8 for example?

Can this be further manipulated to give you the target with a tolerance?

Thanks

Paul
 

Forum statistics

Threads
1,077,768
Messages
5,336,143
Members
399,067
Latest member
CJWFM

Some videos you may like

This Week's Hot Topics

Top