as an example i will use the national lottery. numbers 1 to 49 inclusive.
i need a formula that will list all the possibile 6 number combinations not repeating any.

calling all wizards

thanks in advance