Welcome Guest
You last visited December 3, 2016, 10:44 am
All times shown are
Eastern Time (GMT-5:00)

# Needed: Excel Formula!

Topic closed. 4 replies. Last post 11 years ago by scott_one.

 Page 1 of 1
Lapeer, MI
United States
Member #9977
December 29, 2004
31 Posts
Offline
 Posted: July 13, 2005, 5:20 pm - IP Logged

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.

Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Online
 Posted: July 14, 2005, 12:40 pm - IP Logged

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

Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Online
 Posted: July 14, 2005, 10:08 pm - IP Logged

Those interested in tracking Pairs uisng Excel.

http://www.techonthenet.com/excel/macros/pairs.htm

If you use a large range of past draws you need to adjust the code.

Good Luck!!

wsls

East of Atlanta
United States
Member #6191
August 11, 2004
1389 Posts
Offline
 Posted: July 15, 2005, 7:42 am - IP Logged

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 formula

SUMPRODUCT(--(Cash4History!\$A\$2:\$A\$141 <--Range holding the Day of week

=\$AN\$2) <--Day match to check for

,--(Cash4History!\$D\$2:\$D\$141 <--Range holding the numbers being searched

=\$AM3)) <--Number Match to check for

Lapeer, MI
United States
Member #9977
December 29, 2004
31 Posts
Offline
 Posted: July 16, 2005, 5:45 pm - IP Logged

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

 Page 1 of 1