Thread: Macro Need
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ytayta555 ytayta555 is offline
external usenet poster
 
Posts: 247
Default Macro Need

A good day !

Please very much to provide me this kind of macro which
provide me the next type of combination ( I don't know if
what I need so strong is a combination or a permutation) :

here is an simplified example :

1|1|1|1|0|0|0
1|1|1|0|1|0|0
1|1|1|0|0|1|0
1|1|1|0|0|0|1
1|1|0|1|1|0|0
1|1|0|1|0|1|0
1|1|0|1|0|0|1
1|1|0|0|1|1|0
1|1|0|0|1|0|1
1|1|0|0|0|1|1
1|0|1|1|1|0|0
1|0|1|1|0|1|0
1|0|1|1|0|0|1
1|0|1|0|1|1|0
1|0|1|0|1|0|1
1|0|1|0|0|1|1
1|0|0|1|1|1|0
1|0|0|1|1|0|1
1|0|0|1|0|1|1
1|0|0|0|1|1|1
0|1|1|1|1|0|0
0|1|1|1|0|1|0
0|1|1|1|0|0|1
0|1|1|0|1|1|0
0|1|1|0|1|0|1
0|1|1|0|0|1|1
0|1|0|1|1|1|0
0|1|0|1|1|0|1
0|1|0|1|0|1|1
0|1|0|0|1|1|1
0|0|1|1|1|1|0
0|0|1|1|1|0|1
0|0|1|1|0|1|1
0|0|1|0|1|1|1
0|0|0|1|1|1|1

This kind of combination/permutation I have need , but with first 15
numbers to be 1
and the next 30 numbers to be 0 , totally numbers 45 :
111111111111111000000000000000000000000000000

for more ideas , please read and here :
http://groups.google.ro/group/micros...4ca40126d637c?
, really , it's last my big problem ..

Thanks to all