(January 9, 2015 at 6:38 am)BlackMason Wrote: Where are the excel whizzes? I know how to generate random numbers like the lottery. Problem is sometimes I get duplicates in the same row. The lottery doesn't allow that. What formula can I input to ensure I don't get duplicates in a single lottery combination?
For all the nay sayers telling me I'm wasting my time: Conventional wisdom has it's golden nuggets. But they lie in a river bed filled with fools gold.
Unlike most of you, I want to do science and not just talk about it. Now I've made some observations and I want to test them.
If that's the case, you should procure one of these for your experiment: