Computing permutations ? (2003)

Topic

New Reply

Folks

I

Reply | Quote

Replies

You could create a table like this:

	A	B	C	D
1

Reply | Quote

Sure enough…

Actually I was looking for some way to automate this, having more than two groups (in fact 5) of items to permute…

And at the end of the day what I am REALLY looking for is the MIN and MAX value…

Regards

alex

Reply | Quote

The min and max shouldn’t be too hard, e.g.

=MIN(first range)+MIN(second range)+MIN(third range)+…

You’d probably need VBA to generate all combinations/permutations of elements from 5 groups.

Reply | Quote