# finding the most called numbers in a table

#### mhmunoz68

##### New Member
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>

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
List numbers 1-100 and use countif?

mhmunoz68,

Welcome to the MrExcel forum.

Excel 2007
ABCDEFGHIJKLMNOPQRSTUVWXYZ
15691213333739404243465054586364707275NumberCountMinMax
21011161720232527283032334042485367707475112175
361011151822232930313237495155606465697529
412567151719252629323338395060646771314
5367818343738424449545564666973747548
6710132228293031343637394043455051536472510
74681517192021272933475356586266687175613
8135910192224303443445354555664656974711
9245151620224048495152565961626769727488
10711151619212633343943444546505562676869911
1178910121316193036373851535558626572731015
1269101718232426283234353743475356576174118
131391012131617192129324446495158636874125
14123691619262732444649606467686970721310
15413162024262830313637404656606266677172147
1617142225313233353641454663646768697274158
1712822233031353743505154606768751614
1815101416182430343642455152576264707475179
19451011162130394244465053545658626668741810
2038911232429343842434647485558616468721912
212361213252933353841495253586164677072206
2236101420212327283236444550546466697375218
23123591318212427323738404148546265662210
241271011131527282930313947495257606775238
2524131620212225272938465155565765697174247
26310141516171819232728333846515357606775258
2738141718212332333436404145495460636873268
2814512161819242527293031344450586871732710
291371116182629303132334145606165666769289
30181114172225293339404345464953576467752913
31356791922303848525354596166687073753015
323671019262935464751606265666770717274319
339101315161718283038424347515254585963653212
34234671025303132455659616470717273743311
3545689141922262728434959636570737475349
36355
37367
38379
393810
40397
41408
42415
43427
444310
45448
46459
474612
48476
49485
504910
51508
525111
53526
545311
555410
56557
57568
58576
59589
60595
616010
62617
63629
64636
656414
66659
67669
686714
696811
706910
71709
72717
737211
74738
757413
767513
77
Sheet1
Cell Formulas
RangeFormula
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)

Last edited:
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.

Mike
mhmunoz68,

Welcome to the MrExcel forum.

Excel 2007
ABCDEFGHIJKLMNOPQRSTUVWXYZ
15691213333739404243465054586364707275NumberCountMinMax
21011161720232527283032334042485367707475112175
361011151822232930313237495155606465697529
412567151719252629323338395060646771314
5367818343738424449545564666973747548
6710132228293031343637394043455051536472510
74681517192021272933475356586266687175613
8135910192224303443445354555664656974711
9245151620224048495152565961626769727488
10711151619212633343943444546505562676869911
1178910121316193036373851535558626572731015
1269101718232426283234353743475356576174118
131391012131617192129324446495158636874125
14123691619262732444649606467686970721310
15413162024262830313637404656606266677172147
1617142225313233353641454663646768697274158
1712822233031353743505154606768751614
1815101416182430343642455152576264707475179
19451011162130394244465053545658626668741810
2038911232429343842434647485558616468721912
212361213252933353841495253586164677072206
2236101420212327283236444550546466697375218
23123591318212427323738404148546265662210
241271011131527282930313947495257606775238
2524131620212225272938465155565765697174247
26310141516171819232728333846515357606775258
2738141718212332333436404145495460636873268
2814512161819242527293031344450586871732710
291371116182629303132334145606165666769289
30181114172225293339404345464953576467752913
31356791922303848525354596166687073753015
323671019262935464751606265666770717274319
339101315161718283038424347515254585963653212
34234671025303132455659616470717273743311
3545689141922262728434959636570737475349
36355
37367
38379
393810
40397
41408
42415
43427
444310
45448
46459
474612
48476
49485
504910
51508
525111
53526
545311
555410
56557
57568
58576
59589
60595
616010
62617
63629
64636
656414
66659
67669
686714
696811
706910
71709
72717
737211
74738
757413
767513
77

</tbody>
Sheet1

Worksheet Formulas
CellFormula
Y2=MIN(A1:T35)
Z2=MAX(A1:T35)
W2=COUNTIF(\$A\$1:\$T\$35,V2)

</tbody>

<tbody>
</tbody>

The formula in cell W2, copied down:

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

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.

Mike

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.

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

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.

Last edited:
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

mhmunoz68,

Thank You Very much for your Help

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.

Replies
5
Views
480
Replies
4
Views
256
Replies
3
Views
236
Replies
6
Views
741
Replies
5
Views
337

1,203,072
Messages
6,053,377
Members
444,659
Latest member
vuphihung

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back