Thanks for shedding some light on the matter. Here comes the example:
Column A
2
5
6
7
12
78
44

I would like excel to list me the combination from the database in columnA
for a given number. Combin (7,6) listing will be:
2 2 2 2 2 2 5
5 5 5 5 5 6 6
6 6 6 6 7 7 7
7 7 7 12 12 12 12
12 12 78 78 78 78 78
78 44 44 44 44 44 44

Thanks



"CLR" wrote:

Sorry, guess I mis-understood. I thought you HAD abc, and WANTED
ab,ac,ba,bc,ca,cb. I told you one way to get that. If that is not what
you're after, please give a couple more examples of what you HAVE and what
you WANT. Then perhaps someone can help more.........

Vaya con Dios,
Chuck, CABGx3




"bybora" wrote:

Hello,

Combination is not in the meaning of combining things together. I mean the
combination in maths. As you know it is a way of calculating probability like
permutation.

Thanks.

"CLR" wrote:

If your base numbers were always 3 digits, it would be relatively easy to do
Data TextToColumns and separate them into 3 columns, and then put
CONCATENATION formulas in other cells along the same row to produce the
combinations you seek.......if this sounds like what you want, and if you
need help with it, post back.

Vaya con Dios,
Chuck, CABGx3



"combination?" wrote:

Hello,

From a database, I would like to list a number of combinations. For example
dtabase is a,b,c combination 3,2 listing will be ab,ac,ba,bc,ca,cb.
Is there a way to do it?

Thanks