i need excel to output all lottery combinations. the numbers are from 1-49 from which 6 numbers are drawn. i do realise the number of combinations are 13983816. i want the 6 numbers drawn to be in different cells across 6 different columns. so the 1st 6 numbers are in a1, b1, c1, d1, e1, f1. obviously excel 2003 has 65536 rows and so the formula/vb code should carry on onto a new worksheet or ideally a new workbook. its ideal in a new workbook so not to end up with a single huge 10gig file, but on several worksheets in 1 workbook is fine.
i have been trying to do this myself for a while now with no success. any help would be great. from what i understand; this is a bit of a challenge i know.
i have been trying to do this myself for a while now with no success. any help would be great. from what i understand; this is a bit of a challenge i know.