- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- Trying to generate a solution

Subject: | Trying to generate a solution |

Posted by: | Russ |

Date: | Thu, 18 May 2006 |

Hi. I have four columns, A, B, C, and D. The fifth column is E and is the

sum total of A+B+C+D. I would like to set the total to equal 100 and find

all of the combinations of A, B, C, and D that would add up to equal 100.

(A, B, C, and D are all positive whole numbers.) I think this is a

permutation, because order matters. Is it possible to get Excel to do this?

Also, is it possible to set it up so that each number in A, B, C, and D is a

positive number that increases in intervals of 5, as this would cut down the

number of solutions?

Any help would be greatly appreciated. Thanks.

- Re: Trying to generate a solution posted by Dave O on 18 May 2006
- RE: Trying to generate a solution posted by Dominic LeVasseur on Thu, 18 May 2006