Hi
By any chance could we get a
excel formula for crossing off
pairs and leaving 4 PAIRS left out of
100 draw numbers??---We use only 45 PAIRS--(no reverse pairs)
We STOP as soon as 4 PAIRS are LEFT---
example ---all 100 draws are put in
order 123 ---say that 486 was drawn
we puy it 468 then we make the pairs
100 Draws-----pairs
468-------------46-48-68
677-------------67-77
023-------------02-03-23
ECT---
all numbers are in order..
doubles we use only two sets of pairs..
so we cross off 46-48-68 till we
get down to 4 PAIR LEFT in the
caart below---
00 01 02 03 04 05 06 07 08 09
11 12 13 14 15 16 17 18 19
22 23 24 25 26 27 28 29
33 34 35 36 37 38 39
44 45 46 47 48 49
55 56 57 58 59
66 67 68 69
77 78 79
88 89
99
hope we explained it right..
dont know if it needs a macro formula
or just a excel formula..
thank you
bob from Michigan
By any chance could we get a
excel formula for crossing off
pairs and leaving 4 PAIRS left out of
100 draw numbers??---We use only 45 PAIRS--(no reverse pairs)
We STOP as soon as 4 PAIRS are LEFT---
example ---all 100 draws are put in
order 123 ---say that 486 was drawn
we puy it 468 then we make the pairs
100 Draws-----pairs
468-------------46-48-68
677-------------67-77
023-------------02-03-23
ECT---
all numbers are in order..
doubles we use only two sets of pairs..
so we cross off 46-48-68 till we
get down to 4 PAIR LEFT in the
caart below---
00 01 02 03 04 05 06 07 08 09
11 12 13 14 15 16 17 18 19
22 23 24 25 26 27 28 29
33 34 35 36 37 38 39
44 45 46 47 48 49
55 56 57 58 59
66 67 68 69
77 78 79
88 89
99
hope we explained it right..
dont know if it needs a macro formula
or just a excel formula..
thank you
bob from Michigan