On 11 Iul, 05:55, "Dana DeLouis" wrote:
(..I know that is *a very enormous numbers of combinations )
Yes. *I believe there are this many unique permutations of your data:
=COMBIN(15+30,15)
*344,867,425,584,

At last , they are combinations or permutations what I need , and I
try to built ? Or arrangements ?

(Are you sure you want to list them all?)

I need only some few 40.000.000
___________________________________________
This is a formula :
=AND(MMULT(TRANSPOSE(ROW(B1:F45))^0;ISNUMBER(B1:F4 5)*{1|0|1|0|1|1|0|1|
0|1|1|0|1|0|1|1|0|1|0|1|1|0|1|0|1|0|0|0|0|0|0|0|0| 0|0|0|0|0|0|0|0|0|0|
0|0})<=1)

Generating another arrangements in this array I generate references in
combinatoric order ,
that't why I need the macro which can do that ! ...