I need an EXCEL formula that will help me calculate lotto numbers?
Tbey said there is 1: 1,000,000 chance that a combination will be pick twice. I have all numbers that won since 2002. Now I need to input those numbers in excel and exclude those combination while letting excel pick a random six number set with the numbers 1-54. Is there any formula for this?

Games & Recreation > Gambling