Needed: Excel Formula!

Reply #4

scott_one — Sat, 16 Jul 2005 21:45:38 GMT

Thanks for the replys. That link was just what I was looking for.

Reply #3

SirMetro — Fri, 15 Jul 2005 11:42:49 GMT

You might want to consider this formula...I use it to track how many times a number for a given day of the week has occurred. I am sure it can be adjusted as you need it to check to see when a number has occurred with another number. Of course, I am sure there are better ways to check as well.SUMPRODUCT(--(Cash4History!$A$2:$A$141=$AN$2),--(Cash4History!$D$2:$D$141=$AM3))Breakdown of the formulaSUMPRODUCT(--(Cash4History!$A$2:$A$141 <--Range holding the Day of week=$AN$2) <--Day match to check f... [ More ]

Reply #2

winsumloosesum — Fri, 15 Jul 2005 02:08:50 GMT

Those interested in tracking Pairs uisng Excel.http://www.techonthenet.com/excel/macros/pairs.htm You can adjust the number of digits drawn in your lottery.If you use a large range of past draws you need to adjust the code.Good Luck!!wsls

Reply #1

winsumloosesum — Thu, 14 Jul 2005 16:40:44 GMT

scott_one,Send me a PM with an email address and I will forward you the Excel worksheet with the Fantasy 5 past draws and the Pairs chart.wsls

Needed: Excel Formula!

scott_one — Wed, 13 Jul 2005 21:20:23 GMT

Hello,I have been following the post here regularly and have found members to be very helpful and I was hoping someone could help me out with a formula in excel.I would like to know of a formula for tracking numbers drawn with other numbers in a Fantasy 5 game. Ex. how many times 5 was drawn with 21 etc.Column A is the date of draw and column B thru F are the 5 numbers drawn.Any help would be greatly appreciated.Thank you in advance.