Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COMBINAISON
Hi ! and sorry for my poor english....
I have a number like 100 in A1 and a little list of numbers in B1:Bxx and i would like to find what numbers in B make a total equal to A1 ex:in B1:Bxx 50 2 6 44 12 9 17 23 20 45 40 in this case i have : 50+6+44 = 100 or 17+23+20+40= 100 Is it possible ? Thanks a lot ....Patrick |