excel 2002

[anon125]

lottery. i can get the rows of 6 numbers that have won before.
how do i check if any set of 6 numbers (or maybe 5) have won more than once?

than if none have then i should not choose a set of numbers that have won. how do i do that?

In excel 2002
how do i post a spreadsheet in this forum?

3724 rows of numbers so far.

thanks all

 

[jmacleary]

Hi there.
Apart from the observation that as the lottery is random, the chance of the same combination again is the same as if it hadnt come before, you could create a 'helper column'. Assuming the numbers from each lottery week ar in columns A to F and in ascending order, Place a formula in column G concatenating A to F. this would be: =CONCATENATE(A1,B1,C1,D1,E1,F1)
Then do the same concatenation with the numbers you want to check. Finally use this formula to see how many times the combination has come up: COUNTIF(G:G,N1) - this assumes your concatenated trial number is in column N1.
If you want to go down to 5 values, create 6 helper columns, concatenating 5 of the 6 numbers. You would then use countif against that whole set of numbers.

 

[anon125]

thanks
will give it a try