Hello,
I am currently working on a project that i cannot discuss at present, but i am an absolute Excel novice and my project requires some help from a pro.
What I require is a formula to calculate and list every possible combination of numbers that could be in a 5 digit code that contains any numbers between 1 and 50, but without any duplication of numbers within one set of 5 digits. e.g. a bit like lottery numbers or a safe combination.
I would imagine the total number of possible combinations is somewhere up in the millions, and as such might take quite a while to work out everyone by hand.
I hope that someone can help me or point me in the right direction of how to solve this problem.
I apologise for making this so obscure.
Many thanks
Wayne
I am currently working on a project that i cannot discuss at present, but i am an absolute Excel novice and my project requires some help from a pro.
What I require is a formula to calculate and list every possible combination of numbers that could be in a 5 digit code that contains any numbers between 1 and 50, but without any duplication of numbers within one set of 5 digits. e.g. a bit like lottery numbers or a safe combination.
I would imagine the total number of possible combinations is somewhere up in the millions, and as such might take quite a while to work out everyone by hand.
I hope that someone can help me or point me in the right direction of how to solve this problem.
I apologise for making this so obscure.
Many thanks
Wayne