Hello to all experts in Excel formula programming and mathematicians.
I am trying to develop a formula applicable in Excel that generates possible combinations of 7 numbers within number span from 1 to 50.
Interesting here is that I can`t find a proper way how to fully integrate all needed variables in same formula for expected result.

Following variables I am trying to integrate are these:

1. numbers can be formed from 1 and 2 digits
2. number span to form combination of numbers is from 1 - 50
3. each combination contains 7 different numbers (without repeating inside same combination)
4. numbers should be lined in order from smallest to highest value if possible
5. to simplify (reduce) from all possible combinations, it is crucial that combinations can be generated from "**manually inserted**" chosen numbers (they are within this same numeric span of 1 - 50). This is what I think is most challenging how to create.
6. alternatively, is it possible to integrate in this kind of formula a loop that checks or blocks that same combination of set of 7 numbers are repeated within all combinations? This is to prevent repeating of same set of combination of numbers within ultimate possible of combinations following these all previous conditions.

Thank you for support,
DucyD