Formula in Excel

[smitters]

Hi All.

Can any Excel guru(s) help me to write a formula to show me the last draw id a number has appeared. I don't wan't the frequency formula that I got wright.

Does any body know how too handicap lotto numbers in Excel

Please help.

Thanx

Smitters

 

[GillesD]

Finding if a number is present

You can use the COUNTIF function as in =COUNTIF(Range,Number).

The Range should be the range of the winning numbers and Number the number you want to look for in the winning numbers. It will return the number of times Number can be found in Range.

So =COUNTIF(A1:E1,8) will return 1 if 8 is present in the range A1:E1 and 0 if not.

But that function can be used for many other things when analyzing data from lotteries.

What do you mean by "handicap lotto numbers"?