To quote Myrna Larson earlier today

Go to Google newsgroup search and search for

combination equal number

in groups microsoft.public.excel.*

You'll find lots of hits on how to do this with Solver.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mark4006" wrote in message
...
I have a list of range of data like
A 20
B 3
C 4
D 26
E 10
F 3
G 7


I would like to be able to generate a table with all the combinations of 4
selections which total 40 or less. Any sugestions as to how I could do
this
in excel.