Trying to figure out formula for

Reply #3

lottaloot — Sun, 11 Dec 2005 12:36:11 GMT

Thanks

Reply #2

txp3maven — Sun, 11 Dec 2005 12:28:48 GMT

lottaloot, See if this site helps you ... and thanks for all the posts, you truly are a numbers worst nightmare!!! http://www.techonthenet.com/excel/macros/pairs.php txp3m

Reply #1

lottaloot — Sun, 11 Dec 2005 12:18:38 GMT

I think I'm getting closer (thanks to whoever spoke on naming ranges in another thread) I named my columns H:M where my pairs are (Pairs) =COUNTIF(pairs,AN2) To count the number of times the pairs are seenNow do I simply divide by the draws to obtain the % that each pair hits

Trying to figure out formula for

lottaloot — Sun, 11 Dec 2005 11:54:15 GMT

actual hits of the pairs within my spreadsheet. I just was never any good at math.I would like to calculate the actual pair hits then determine the average amount of skips between hits.I would like the pairs to be non-specific in their position (meaning I don't care about front or back pair hits for now)I figure all I had to do was divide the lottery draws by the actual hits of the pairs; however, I have what I am sure is called an array formula for counting the skips of my pairs.=MATCH(TRUE,M... [ More ]