Possible combinations of data in an array, always only one row per each column

[JanFoo]

Hi,
I need to list all possible combinations of an array:

A1 B1 C1 D1 E1
A2 B2 C2 D2 E2
A3 B3 C3 D3 E3

The problem is, I need to list all the combinations of 1 to 5 values i. e. from A1 > through > B2 C3 E2 > till > A3 B3 C3 D3 E3,
without repetition of a column in a single result.

I mean I need to exclude results which contain the same letter twice - like A1 A2 or B2 B3 D3 or C1 C2 C3 etc.

Does anyone have an idea?

Many thanks!

[Bernie Deitrick]

Try this code: I've assumed that your array is actually in cells A1 to E3, and that columns H:L are open for storing the combinations of values.

Please Login or Register  to view this content.

[JanFoo]

Thanks a lot! It helped me to get what I needed.

[JanFoo]

Thanks a lot! It helped me to get what I needed :-)