create all formations from 000 to 666 no repetition ,

create all formations from 000 to 666
no repetition
ex=
are not the digits! but repeated formations that have been excluded
example
we have 001
010
100
010

I just need to train this group
ok=001
and so with the other formations, are repeated formations that have excluded
another example
443
434
344
434
344
so i need a formation 443 ok
https://www.excelforum.com/attachmen...1&d=1639622243

Or try this in A5:

=INT(MOD((ROWS($A$5:A5)-1)/49,7))

in B5:

=INT(MOD((ROWS($B$5:B5)-1)/7,7))

in C5:

=MOD(ROWS($C$5:C5)-1,7)

hello =crooza! I'm not getting it to work, is it because the formulas are in English? please

hello it has to be in the crescent, it cannot have duplicity, ex=
001
010
100
only one in crescent 001 and so on with the others
have to remove duplicity, the matrix tends to be perfect 10%

I Tried! but I can't activate the formula!

I tried many times, the formulas are not working as well, can you help me please