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,

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

<colgroup><col span="7"><col><col><col></colgroup><tbody>
</tbody>

 

[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.