finding the most called numbers in a table

[mhmunoz68]

Hi Everyone,
I have been trying to figure out how to find the most called numbers in a group of numbers in excel.
I want to find out the most called numbers in this example below, how many variations?
I have office 365
Any help would be greatly appreciated.

Mike

5	6	9	12	13	33	37	39	40	42	43	46	50	54	58	63	64	70	72	75
10	11	16	17	20	23	25	27	28	30	32	33	40	42	48	53	67	70	74	75
6	10	11	15	18	22	23	29	30	31	32	37	49	51	55	60	64	65	69	75
1	2	5	6	7	15	17	19	25	26	29	32	33	38	39	50	60	64	67	71
3	6	7	8	18	34	37	38	42	44	49	54	55	64	66	69	73	74	75
7	10	13	22	28	29	30	31	34	36	37	39	40	43	45	50	51	53	64	72
4	6	8	15	17	19	20	21	27	29	33	47	53	56	58	62	66	68	71	75
1	3	5	9	10	19	22	24	30	34	43	44	53	54	55	56	64	65	69	74
2	4	5	15	16	20	22	40	48	49	51	52	56	59	61	62	67	69	72	74
7	11	15	16	19	21	26	33	34	39	43	44	45	46	50	55	62	67	68	69
7	8	9	10	12	13	16	19	30	36	37	38	51	53	55	58	62	65	72	73
6	9	10	17	18	23	24	26	28	32	34	35	37	43	47	53	56	57	61	74
1	3	9	10	12	13	16	17	19	21	29	32	44	46	49	51	58	63	68	74
1	2	3	6	9	16	19	26	27	32	44	46	49	60	64	67	68	69	70	72
4	13	16	20	24	26	28	30	31	36	37	40	46	56	60	62	66	67	71	72
1	7	14	22	25	31	32	33	35	36	41	45	46	63	64	67	68	69	72	74
1	2	8	22	23	30	31	35	37	43	50	51	54	60	67	68	75
1	5	10	14	16	18	24	30	34	36	42	45	51	52	57	62	64	70	74	75
4	5	10	11	16	21	30	39	42	44	46	50	53	54	56	58	62	66	68	74
3	8	9	11	23	24	29	34	38	42	43	46	47	48	55	58	61	64	68	72
2	3	6	12	13	25	29	33	35	38	41	49	52	53	58	61	64	67	70	72
3	6	10	14	20	21	23	27	28	32	36	44	45	50	54	64	66	69	73	75
1	2	3	5	9	13	18	21	24	27	32	37	38	40	41	48	54	62	65	66
1	2	7	10	11	13	15	27	28	29	30	31	39	47	49	52	57	60	67	75
2	4	13	16	20	21	22	25	27	29	38	46	51	55	56	57	65	69	71	74
3	10	14	15	16	17	18	19	23	27	28	33	38	46	51	53	57	60	67	75
3	8	14	17	18	21	23	32	33	34	36	40	41	45	49	54	60	63	68	73
1	4	5	12	16	18	19	24	25	27	29	30	31	34	44	50	58	68	71	73
1	3	7	11	16	18	26	29	30	31	32	33	41	45	60	61	65	66	67	69
1	8	11	14	17	22	25	29	33	39	40	43	45	46	49	53	57	64	67	75
3	5	6	7	9	19	22	30	38	48	52	53	54	59	61	66	68	70	73	75
3	6	7	10	19	26	29	35	46	47	51	60	62	65	66	67	70	71	72	74
9	10	13	15	16	17	18	28	30	38	42	43	47	51	52	54	58	59	63	65
2	3	4	6	7	10	25	30	31	32	45	56	59	61	64	70	71	72	73	74
4	5	6	8	9	14	19	22	26	27	28	43	49	59	63	65	70	73	74	75

<colgroup><col><col><col span="2"><col span="2"><col><col><col span="3"><col><col span="2"><col span="2"><col><col span="2"><col></colgroup><tbody>
</tbody>

 

[Kyle123]

List numbers 1-100 and use countif?

 

[hiker95]

mhmunoz68,

Welcome to the MrExcel forum.

How about something like this?

Excel 2007
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
1	5	6	9	12	13	33	37	39	40	42	43	46	50	54	58	63	64	70	72	75		Number	Count		Min	Max
2	10	11	16	17	20	23	25	27	28	30	32	33	40	42	48	53	67	70	74	75		1	12		1	75
3	6	10	11	15	18	22	23	29	30	31	32	37	49	51	55	60	64	65	69	75		2	9
4	1	2	5	6	7	15	17	19	25	26	29	32	33	38	39	50	60	64	67	71		3	14
5	3	6	7	8	18	34	37	38	42	44	49	54	55	64	66	69	73	74	75			4	8
6	7	10	13	22	28	29	30	31	34	36	37	39	40	43	45	50	51	53	64	72		5	10
7	4	6	8	15	17	19	20	21	27	29	33	47	53	56	58	62	66	68	71	75		6	13
8	1	3	5	9	10	19	22	24	30	34	43	44	53	54	55	56	64	65	69	74		7	11
9	2	4	5	15	16	20	22	40	48	49	51	52	56	59	61	62	67	69	72	74		8	8
10	7	11	15	16	19	21	26	33	34	39	43	44	45	46	50	55	62	67	68	69		9	11
11	7	8	9	10	12	13	16	19	30	36	37	38	51	53	55	58	62	65	72	73		10	15
12	6	9	10	17	18	23	24	26	28	32	34	35	37	43	47	53	56	57	61	74		11	8
13	1	3	9	10	12	13	16	17	19	21	29	32	44	46	49	51	58	63	68	74		12	5
14	1	2	3	6	9	16	19	26	27	32	44	46	49	60	64	67	68	69	70	72		13	10
15	4	13	16	20	24	26	28	30	31	36	37	40	46	56	60	62	66	67	71	72		14	7
16	1	7	14	22	25	31	32	33	35	36	41	45	46	63	64	67	68	69	72	74		15	8
17	1	2	8	22	23	30	31	35	37	43	50	51	54	60	67	68	75					16	14
18	1	5	10	14	16	18	24	30	34	36	42	45	51	52	57	62	64	70	74	75		17	9
19	4	5	10	11	16	21	30	39	42	44	46	50	53	54	56	58	62	66	68	74		18	10
20	3	8	9	11	23	24	29	34	38	42	43	46	47	48	55	58	61	64	68	72		19	12
21	2	3	6	12	13	25	29	33	35	38	41	49	52	53	58	61	64	67	70	72		20	6
22	3	6	10	14	20	21	23	27	28	32	36	44	45	50	54	64	66	69	73	75		21	8
23	1	2	3	5	9	13	18	21	24	27	32	37	38	40	41	48	54	62	65	66		22	10
24	1	2	7	10	11	13	15	27	28	29	30	31	39	47	49	52	57	60	67	75		23	8
25	2	4	13	16	20	21	22	25	27	29	38	46	51	55	56	57	65	69	71	74		24	7
26	3	10	14	15	16	17	18	19	23	27	28	33	38	46	51	53	57	60	67	75		25	8
27	3	8	14	17	18	21	23	32	33	34	36	40	41	45	49	54	60	63	68	73		26	8
28	1	4	5	12	16	18	19	24	25	27	29	30	31	34	44	50	58	68	71	73		27	10
29	1	3	7	11	16	18	26	29	30	31	32	33	41	45	60	61	65	66	67	69		28	9
30	1	8	11	14	17	22	25	29	33	39	40	43	45	46	49	53	57	64	67	75		29	13
31	3	5	6	7	9	19	22	30	38	48	52	53	54	59	61	66	68	70	73	75		30	15
32	3	6	7	10	19	26	29	35	46	47	51	60	62	65	66	67	70	71	72	74		31	9
33	9	10	13	15	16	17	18	28	30	38	42	43	47	51	52	54	58	59	63	65		32	12
34	2	3	4	6	7	10	25	30	31	32	45	56	59	61	64	70	71	72	73	74		33	11
35	4	5	6	8	9	14	19	22	26	27	28	43	49	59	63	65	70	73	74	75		34	9
36																						35	5
37																						36	7
38																						37	9
39																						38	10
40																						39	7
41																						40	8
42																						41	5
43																						42	7
44																						43	10
45																						44	8
46																						45	9
47																						46	12
48																						47	6
49																						48	5
50																						49	10
51																						50	8
52																						51	11
53																						52	6
54																						53	11
55																						54	10
56																						55	7
57																						56	8
58																						57	6
59																						58	9
60																						59	5
61																						60	10
62																						61	7
63																						62	9
64																						63	6
65																						64	14
66																						65	9
67																						66	9
68																						67	14
69																						68	11
70																						69	10
71																						70	9
72																						71	7
73																						72	11
74																						73	8
75																						74	13
76																						75	13
77
Sheet1

Cell Formulas
Range	Formula
Y2	=MIN(A1:T35)
Z2	=MAX(A1:T35)
W2	=COUNTIF($A$1:$T$35,V2)

The formula in cell W2, copied down:

=COUNTIF($A$1:$T$35,V2)

 

[mhmunoz68]

Hi Hiker95,
Thank you, this is what I'm looking for but how do you do this in excel? the steps? I'm still in the learning phase of Excel.
I go to play Bingo often and the call 8 numbers out of 75 so I have been keeping track of the numbers and I have been trying to figure out on Excel how to track the most called numbers.
I appreciate your Help

Mike

mhmunoz68,

Welcome to the MrExcel forum.

How about something like this?

Excel 2007

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
1	5	6	9	12	13	33	37	39	40	42	43	46	50	54	58	63	64	70	72	75		Number	Count		Min	Max
2	10	11	16	17	20	23	25	27	28	30	32	33	40	42	48	53	67	70	74	75		1	12		1	75
3	6	10	11	15	18	22	23	29	30	31	32	37	49	51	55	60	64	65	69	75		2	9
4	1	2	5	6	7	15	17	19	25	26	29	32	33	38	39	50	60	64	67	71		3	14
5	3	6	7	8	18	34	37	38	42	44	49	54	55	64	66	69	73	74	75			4	8
6	7	10	13	22	28	29	30	31	34	36	37	39	40	43	45	50	51	53	64	72		5	10
7	4	6	8	15	17	19	20	21	27	29	33	47	53	56	58	62	66	68	71	75		6	13
8	1	3	5	9	10	19	22	24	30	34	43	44	53	54	55	56	64	65	69	74		7	11
9	2	4	5	15	16	20	22	40	48	49	51	52	56	59	61	62	67	69	72	74		8	8
10	7	11	15	16	19	21	26	33	34	39	43	44	45	46	50	55	62	67	68	69		9	11
11	7	8	9	10	12	13	16	19	30	36	37	38	51	53	55	58	62	65	72	73		10	15
12	6	9	10	17	18	23	24	26	28	32	34	35	37	43	47	53	56	57	61	74		11	8
13	1	3	9	10	12	13	16	17	19	21	29	32	44	46	49	51	58	63	68	74		12	5
14	1	2	3	6	9	16	19	26	27	32	44	46	49	60	64	67	68	69	70	72		13	10
15	4	13	16	20	24	26	28	30	31	36	37	40	46	56	60	62	66	67	71	72		14	7
16	1	7	14	22	25	31	32	33	35	36	41	45	46	63	64	67	68	69	72	74		15	8
17	1	2	8	22	23	30	31	35	37	43	50	51	54	60	67	68	75					16	14
18	1	5	10	14	16	18	24	30	34	36	42	45	51	52	57	62	64	70	74	75		17	9
19	4	5	10	11	16	21	30	39	42	44	46	50	53	54	56	58	62	66	68	74		18	10
20	3	8	9	11	23	24	29	34	38	42	43	46	47	48	55	58	61	64	68	72		19	12
21	2	3	6	12	13	25	29	33	35	38	41	49	52	53	58	61	64	67	70	72		20	6
22	3	6	10	14	20	21	23	27	28	32	36	44	45	50	54	64	66	69	73	75		21	8
23	1	2	3	5	9	13	18	21	24	27	32	37	38	40	41	48	54	62	65	66		22	10
24	1	2	7	10	11	13	15	27	28	29	30	31	39	47	49	52	57	60	67	75		23	8
25	2	4	13	16	20	21	22	25	27	29	38	46	51	55	56	57	65	69	71	74		24	7
26	3	10	14	15	16	17	18	19	23	27	28	33	38	46	51	53	57	60	67	75		25	8
27	3	8	14	17	18	21	23	32	33	34	36	40	41	45	49	54	60	63	68	73		26	8
28	1	4	5	12	16	18	19	24	25	27	29	30	31	34	44	50	58	68	71	73		27	10
29	1	3	7	11	16	18	26	29	30	31	32	33	41	45	60	61	65	66	67	69		28	9
30	1	8	11	14	17	22	25	29	33	39	40	43	45	46	49	53	57	64	67	75		29	13
31	3	5	6	7	9	19	22	30	38	48	52	53	54	59	61	66	68	70	73	75		30	15
32	3	6	7	10	19	26	29	35	46	47	51	60	62	65	66	67	70	71	72	74		31	9
33	9	10	13	15	16	17	18	28	30	38	42	43	47	51	52	54	58	59	63	65		32	12
34	2	3	4	6	7	10	25	30	31	32	45	56	59	61	64	70	71	72	73	74		33	11
35	4	5	6	8	9	14	19	22	26	27	28	43	49	59	63	65	70	73	74	75		34	9
36																						35	5
37																						36	7
38																						37	9
39																						38	10
40																						39	7
41																						40	8
42																						41	5
43																						42	7
44																						43	10
45																						44	8
46																						45	9
47																						46	12
48																						47	6
49																						48	5
50																						49	10
51																						50	8
52																						51	11
53																						52	6
54																						53	11
55																						54	10
56																						55	7
57																						56	8
58																						57	6
59																						58	9
60																						59	5
61																						60	10
62																						61	7
63																						62	9
64																						63	6
65																						64	14
66																						65	9
67																						66	9
68																						67	14
69																						68	11
70																						69	10
71																						70	9
72																						71	7
73																						72	11
74																						73	8
75																						74	13
76																						75	13
77

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula Y2 =MIN(A1:T35) Z2 =MAX(A1:T35) W2 =COUNTIF($A$1:$T$35,V2) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

The formula in cell W2, copied down:

=COUNTIF($A$1:$T$35,V2)

 

[mhmunoz68]

Hi Hiker95,
Thank you, this is what I'm looking for but how do you do this in excel? the steps? I'm still in the learning phase of Excel.
I go to play Bingo often and the call 8 numbers out of 75 so I have been keeping track of the numbers and I have been trying to figure out on Excel how to track the most called numbers.
I appreciate your Help

Mike

 

[hiker95]

mhmunoz68,

Unless there is a particular reason to do so, it is best not to quote whole long replies like you did with mine. It makes the thread harder to navigate/read and just takes up unnecessary space.

1. Quote ONLY if it is needed to add clarity or context for your reply. If so, then
2. Quote ONLY the specific part of the post that is relevant - - not the entire post.

This will keep thread clutter to a minimum and make the discussion easier to follow.

this is what I'm looking for but how do you do this in excel?

I have been trying to figure out how to find the most called numbers in a group of numbers in excel.

You may want to search the web for:

Excel Bingo templates, or, Excel Bingo templates free


Do you have a specific question, with detailed instructions?

I am unsure of what you are asking for.

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[mhmunoz68]

Sorry about that hiker95,
I'm new to this internet thread and I have never asked for help, I'm in the learning process.
Your formula will work for me but can you tell me the steps to get to that formula or direct me where to look?

Thank you again for your help

Mike

 

[hiker95]

mhmunoz68,

Your formula will work for me but can you tell me the steps to get to that formula or direct me where to look?

In my reply #3, column V lists all the 75 numbers in the game based on your posted numbers in your reply #1.

The formula in cell W2 is:
=COUNTIF($A$1:$T$35,V2)

You copy that formula down to the last used row which in this case is cell W76.

If you add more raw data from additional games, then you will have to adjust that formula.

If you add more raw data rows, say to row 50, then you will have to adjust the formula in cell W2 like this:
=COUNTIF($A$1:$T$50,V2)

Then copy the new formula in cell W2, down to cell W76.

I would suggest that you search for, and, attend an Excel basic/beginners training class in your local area to learn more about using formulae.

 

[mhmunoz68]

mhmunoz68,



In my reply #3, column V lists all the 75 numbers in the game based on your posted numbers in your reply #1.

The formula in cell W2 is:
=COUNTIF($A$1:$T$35,V2)

You copy that formula down to the last used row which in this case is cell W76.

If you add more raw data from additional games, then you will have to adjust that formula.

If you add more raw data rows, say to row 50, then you will have to adjust the formula in cell W2 like this:
=COUNTIF($A$1:$T$50,V2)

Then copy the new formula in cell W2, down to cell W76.

I would suggest that you search for, and, attend an Excel basic/beginners training class in your local area to learn more about using formulae.

Thank You Very much for your Help

 

[hiker95]

mhmunoz68,

Thank You Very much for your Help

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.