generate all 5 digit formations distinct, in each position,

[jorel]

generate all 5 digit formations
distinct, in each position,
there can be no repetition of digits type 55321, no
cannot be in ascending order
formations must be positional
ex = 9,1,2,4,8
https://www.excelforum.com/attachmen...1&d=1603195718

[6StringJazzer]

formations must be positional What does that mean?

In your example, the digits 1,2,4,8 are in ascending order, which violates the rule you gave. Can you be more rigorous about your specification?

[jorel]

hello 6Stringjazzerthanks for viewing the post but have a positional example ex = 9,1,2,4,8
formations of 5 distinct digits, cannot be ascending must be positional = type ex = 9,1,2,4,8, etc.

[jorel]

of course, some formations will be growing, in the context, others will be decreasing, but most will be positional

[Kaper]

You could use such code to get the list of 30240 (10*9*8*7*6) formations:

Please Login or Register  to view this content.

[Kaper]

PS. From the formal point - these are variations without repetitions. See for instance: https://www.mathreference.org/index/page/id/52/lg/en

[jorel]

ok , kaper, conglatulations, thank you