Check repeated draw numbers on Florida lottery History > 2000 rows :(

Check repeated 6-draw numbers on Florida lottery History, how is played (Select six numbers from 1 through 53) link if may need http://flalottery.com/lotto-howToPlay.do

winning numbers link http://flalottery.com/exptkt/l6.htm

my idea was t give a value for each row, we need to check rows by rows since each rows was a (set of 6 winner numbers) in the past

the idea is did the Florida lottery did any time draw the same 6-pack of numbers more than 1 time?

IF yes how many time this happen, and with those 6-pack of numbers was?

Its worth to play a 6-pack of numbers that have been draw before?

I already down load the 21 pages double column history and converted to 42 pages since I put them as one column

So we have 2054 rows to check between them self for absolute PAIRS, and than we need to indicate with pair go with pair in case would be more than 1 or 2 (maybe by color, pair number, line number, ... )

I find something, but was to find only by numbers and this don't work since I need row by row like on may/25/2013 the draw row was ($1$21$26$30$46$48) so have this row been draw before

I am so lost, and I know this is going to be very labor intensive

[B][/B]

21 24 33 37 43 46
1 11 19 33 37 49
5 6 13 33 35 40
20 23 26 32 41 46
9 14 17 23 25 29
5 17 18 24 29 33
4 9 17 21 35 51
10 12 17 28 38 44
12 14 27 30 36 44
7 8 33 35 39 40
1 5 8 39 52 53
6 15 40 45 51 52
14 21 24 32 41 45
2 13 16 17 20 40
6 7 20 46 48 51
4 9 13 40 41 50
19 24 25 26 28 44
6 11 13 24 35 53
7 11 23 30 35 47
1 6 24 27 33 53
15 30 34 44 47 49
1 7 10 12 33 51
3 12 39 44 46 51


I don't think we need the data neither X#
just the 6 draw numbers are too much

sorry I didn't understanding your idea very well, would you may to explain again, please!!

what I need is, like those rows above I have a total of 2059 rows, my need is, is there any repeated row (not individual numbers) (rows)

21 24 33 37 43 46
1 11 19 33 37 49
5 6 13 33 35 40
20 23 26 32 41 46
9 14 17 23 25 29
5 17 18 24 29 33
4 9 17 21 35 51
10 12 17 28 38 44
12 14 27 30 36 44
7 8 33 35 39 40
1 5 8 39 52 53
6 15 40 45 51 52
14 21 24 32 41 45
2 13 16 17 20 40
6 7 20 46 48 51
4 9 13 40 41 50
19 24 25 26 28 44
6 11 13 24 35 53
7 11 23 30 35 47
1 6 24 27 33 53
15 30 34 44 47 49
1 7 10 12 33 51
3 12 39 44 46 51


I don't think we need the data neither X#
just the 6 draw numbers are too much

sorry I didn't understanding your idea very well, would you may to explain again, please!!

what I need is, like those rows above I have a total of 2059 rows, my need is, is there any repeated row (not individual numbers) (rows)

here is the full file

Hey SHG tks for reply again, but you get me lost there, sorry I am not that good, I don't see working would you please show us a sample formula! tks.

Tks again SHG, but I don't need to know how many times any ball was repeated, that would be just too many, I need to know if any (set of 6 balls/draw winner/row) ever listed at the list I provided, was ever listed twice or even more.

would you please show me working your idea, maybe I am just blind, sorry

bump Help anyone please

Hey Spencer 101 and SHG, tks for the try but i was trying to get multiples of draw numbers (but not the individual numbers) i was looking for the set of 6 draw numbers beside that this formula is good for nothing as you can see the results will all ways be positive/1 since you are including the number self for checking for multiples numbers; any way based on all the tutorials i find on youtube i develop my self those 2 formulas can you or any one else check and tell me if it is trusted, its already working for what i need however i dont now if it trusted or not.

tks your all

b rgds

Fasspho