(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?
You aren't going to get random numbers from Excel, or from anything else on a personal computer. They're pseudorandom - which essentially means "random enough for most purposes". But not this one.