I want find numbers repetition in lottery list

[febausa]

Please help in excel formula.

I want find numbers repetition (double and triple numbers hit/win) in historic lottery list.

 

[FDibbins]

You dont give any details to go on, but try using =countif()

 

[febausa]

Hi, thank you for your help.
I attach a example, I made manually.
Any question send me e-mail.

Thank you,

[TABLE="width: 641"]
<colgroup><col span="7"><col><col><col></colgroup><tbody>[TR]
[TD]Draw Date[/TD]
[TD]Ball # 1[/TD]
[TD]Ball # 2[/TD]
[TD]Ball # 3[/TD]
[TD]Ball # 4[/TD]
[TD]Ball # 5[/TD]
[TD][/TD]
[TD]NUMBER REPETION[/TD]
[TD]DATE[/TD]
[TD]DRAW INTERVAL[/TD]
[/TR]
[TR]
[TD]6/1/2013[/TD]
[TD]11[/TD]
[TD]6[/TD]
[TD]55[/TD]
[TD]42[/TD]
[TD]40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/1/2013[/TD]
[TD]56[/TD]
[TD]37[/TD]
[TD]17[/TD]
[TD]57[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/1/2013[/TD]
[TD]34[/TD]
[TD]8[/TD]
[TD]5[/TD]
[TD]15[/TD]
[TD]59[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/1/2013[/TD]
[TD]42[/TD]
[TD]53[/TD]
[TD]45[/TD]
[TD]4[/TD]
[TD]26[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/1/2013[/TD]
[TD]33[/TD]
[TD]53[/TD]
[TD]59[/TD]
[TD]22[/TD]
[TD]28[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/1/2013[/TD]
[TD]31[/TD]
[TD]59[/TD]
[TD]24[/TD]
[TD]41[/TD]
[TD]54[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/5/2013[/TD]
[TD]47[/TD]
[TD]9[/TD]
[TD]5[/TD]
[TD]48[/TD]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/5/2013[/TD]
[TD]59[/TD]
[TD]16[/TD]
[TD]53[/TD]
[TD]5[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/5/2013[/TD]
[TD]42[/TD]
[TD]18[/TD]
[TD]34[/TD]
[TD]59[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/5/2013[/TD]
[TD]16[/TD]
[TD]37[/TD]
[TD]11[/TD]
[TD]44[/TD]
[TD]18[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/5/2013[/TD]
[TD]4[/TD]
[TD]36[/TD]
[TD]26[/TD]
[TD]33[/TD]
[TD]55[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/5/2013[/TD]
[TD]11[/TD]
[TD]6[/TD]
[TD]27[/TD]
[TD]9[/TD]
[TD]35[/TD]
[TD][/TD]
[TD]6 , 11[/TD]
[TD]6/5/2013[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]7/6/2013[/TD]
[TD]52[/TD]
[TD]29[/TD]
[TD]36[/TD]
[TD]57[/TD]
[TD]40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/6/2013[/TD]
[TD]34[/TD]
[TD]52[/TD]
[TD]54[/TD]
[TD]14[/TD]
[TD]27[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/6/2013[/TD]
[TD]52[/TD]
[TD]10[/TD]
[TD]27[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/6/2013[/TD]
[TD]13[/TD]
[TD]9[/TD]
[TD]19[/TD]
[TD]16[/TD]
[TD]20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/6/2013[/TD]
[TD]52[/TD]
[TD]2[/TD]
[TD]36[/TD]
[TD]35[/TD]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/6/2013[/TD]
[TD]25[/TD]
[TD]28[/TD]
[TD]53[/TD]
[TD]59[/TD]
[TD]40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/17/2013[/TD]
[TD]27[/TD]
[TD]24[/TD]
[TD]13[/TD]
[TD]57[/TD]
[TD]19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/17/2013[/TD]
[TD]6[/TD]
[TD]32[/TD]
[TD]43[/TD]
[TD]19[/TD]
[TD]33[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/17/2013[/TD]
[TD]15[/TD]
[TD]51[/TD]
[TD]43[/TD]
[TD]5[/TD]
[TD]54[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/17/2013[/TD]
[TD]29[/TD]
[TD]51[/TD]
[TD]27[/TD]
[TD]44[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/17/2013[/TD]
[TD]22[/TD]
[TD]1[/TD]
[TD]42[/TD]
[TD]38[/TD]
[TD]34[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/17/2013[/TD]
[TD]52[/TD]
[TD]30[/TD]
[TD]57[/TD]
[TD]6[/TD]
[TD]42[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/31/2013[/TD]
[TD]38[/TD]
[TD]45[/TD]
[TD]53[/TD]
[TD]14[/TD]
[TD]26[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/31/2013[/TD]
[TD]20[/TD]
[TD]57[/TD]
[TD]50[/TD]
[TD]17[/TD]
[TD]38[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/31/2013[/TD]
[TD]28[/TD]
[TD]50[/TD]
[TD]58[/TD]
[TD]48[/TD]
[TD]55[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/31/2013[/TD]
[TD]38[/TD]
[TD]1[/TD]
[TD]24[/TD]
[TD]41[/TD]
[TD]54[/TD]
[TD][/TD]
[TD]24 , 41 , 54 [/TD]
[TD]7/31/2013[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]7/31/2013[/TD]
[TD]8[/TD]
[TD]24[/TD]
[TD]59[/TD]
[TD]39[/TD]
[TD]49[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/31/2013[/TD]
[TD]10[/TD]
[TD]49[/TD]
[TD]47[/TD]
[TD]2[/TD]
[TD]57[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[shahfahad]

=MODE($B$1:$B$30)

Mode function returns the most common value. Is this what you want?

 

[febausa]

Your recommendation seems appropriate but I do not know how to search for two or three winning numbers winning numbers as shown in the attached sample.

Thank you for your help.

 

[febausa]

Please suggest me the appropriate excel formulas to study them and apply them. Thanks for your help

 

[Joe4]

I would recommend creating a list of all possible numbers, and then doing a count of each one.
So, for example, if your data was in the range B2:F100,
then maybe starting in cell M1, enter 1,
in M2 enter: = M1+1
and copy down until you get to your last possible number (60?).
Then in N1, enter this formula and copy down for all rows:
=COUNTIF($B$2:$F$100,M1)

 

[shahfahad]

Hey Joe4, if we use the FREQUENCY function we can get the number of occurrences for each number. But is there a way to match the number of occurrences with the actual number in the list.

 

[Joe4]

Hey Joe4, if we use the FREQUENCY function we can get the number of occurrences for each number. But is there a way to match the number of occurrences with the actual number in the list.

Not sure that applies here. You typically use FREQUENCY to find out how often a value occurs within a range of values (see: FREQUENCY - Excel).

The COUNTIF suggestion given by FDibbins and myself will count the number of occurrences of each possible value. You can even use Conditional Formatting to highlight the numbers that occur more than once (to satisfy the following statement):

I want find numbers repetition (double and triple numbers hit/win) in historic lottery list.

 

[febausa]

Thank you, I sucess in use =COUNTIF , but I don't know as use this formula for find double and triple repetition of hit or win.

Please advise me about it.