|Posted: April 3, 2007, 5:39 am - IP Logged|
to get a list count of all the pairs
in column e1 thru e100 enter 00 thru 99
(to get a leading zero, from the top menu go to format/cells/number/custom and enter 00)
let's assume you have 9000 numbers
in f1, enter
then drag it down to f100
this will count ALL of the pairs without differentiation
if you want to count all pairs and determine front pair/back pair/bookends...
in f1 (for front pair)
in g1 (for back pair)
in h1 (for bookends)
drag(autofill) these down to f100, g100 and h100, respectively
Playing more than one ticket per game is betting against yourself.