Selecting 7 numbers from a weighted list of numbers

A

AndyStanton

New Member
Joined
Mar 6, 2018
Messages
4
Hi All,

I'm trying to generate a list of 7 random numbers from a list of 45 numbers which each have a previous frequency of selection. I'm trying to weight the random numbers to the previous frequency. Any assistance would be great!

Kind Regards,
Andy

[TABLE="width: 336"]
<colgroup><col span="2"><col><col></colgroup><tbody>[TR]
[TD]Number[/TD]
[TD]Frequency[/TD]
[TD]Frequency % of total [/TD]
[TD]Cumulative[/TD]
[/TR]
[TR]
[TD="align: right"]33[/TD]
[TD="align: right"]149[/TD]
[TD="align: right"]0.025627795[/TD]
[TD="align: right"]0.025628[/TD]
[/TR]
[TR]
[TD="align: right"]19[/TD]
[TD="align: right"]144[/TD]
[TD="align: right"]0.024767802[/TD]
[TD="align: right"]0.050396[/TD]
[/TR]
[TR]
[TD="align: right"]40[/TD]
[TD="align: right"]144[/TD]
[TD="align: right"]0.024767802[/TD]
[TD="align: right"]0.075163[/TD]
[/TR]
[TR]
[TD="align: right"]25[/TD]
[TD="align: right"]143[/TD]
[TD="align: right"]0.024595803[/TD]
[TD="align: right"]0.099759[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]141[/TD]
[TD="align: right"]0.024251806[/TD]
[TD="align: right"]0.124011[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]140[/TD]
[TD="align: right"]0.024079807[/TD]
[TD="align: right"]0.148091[/TD]
[/TR]
[TR]
[TD="align: right"]28[/TD]
[TD="align: right"]139[/TD]
[TD="align: right"]0.023907809[/TD]
[TD="align: right"]0.171999[/TD]
[/TR]
[TR]
[TD="align: right"]35[/TD]
[TD="align: right"]139[/TD]
[TD="align: right"]0.023907809[/TD]
[TD="align: right"]0.195906[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]138[/TD]
[TD="align: right"]0.02373581[/TD]
[TD="align: right"]0.219642[/TD]
[/TR]
[TR]
[TD="align: right"]21[/TD]
[TD="align: right"]138[/TD]
[TD="align: right"]0.02373581[/TD]
[TD="align: right"]0.243378[/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD="align: right"]137[/TD]
[TD="align: right"]0.023563811[/TD]
[TD="align: right"]0.266942[/TD]
[/TR]
[TR]
[TD="align: right"]27[/TD]
[TD="align: right"]136[/TD]
[TD="align: right"]0.023391813[/TD]
[TD="align: right"]0.290334[/TD]
[/TR]
[TR]
[TD="align: right"]37[/TD]
[TD="align: right"]136[/TD]
[TD="align: right"]0.023391813[/TD]
[TD="align: right"]0.313725[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]135[/TD]
[TD="align: right"]0.023219814[/TD]
[TD="align: right"]0.336945[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]135[/TD]
[TD="align: right"]0.023219814[/TD]
[TD="align: right"]0.360165[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]134[/TD]
[TD="align: right"]0.023047816[/TD]
[TD="align: right"]0.383213[/TD]
[/TR]
[TR]
[TD="align: right"]45[/TD]
[TD="align: right"]134[/TD]
[TD="align: right"]0.023047816[/TD]
[TD="align: right"]0.406261[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]133[/TD]
[TD="align: right"]0.022875817[/TD]
[TD="align: right"]0.429137[/TD]
[/TR]
[TR]
[TD="align: right"]16[/TD]
[TD="align: right"]133[/TD]
[TD="align: right"]0.022875817[/TD]
[TD="align: right"]0.452012[/TD]
[/TR]
[TR]
[TD="align: right"]26[/TD]
[TD="align: right"]133[/TD]
[TD="align: right"]0.022875817[/TD]
[TD="align: right"]0.474888[/TD]
[/TR]
[TR]
[TD="align: right"]43[/TD]
[TD="align: right"]133[/TD]
[TD="align: right"]0.022875817[/TD]
[TD="align: right"]0.497764[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]131[/TD]
[TD="align: right"]0.02253182[/TD]
[TD="align: right"]0.520296[/TD]
[/TR]
[TR]
[TD="align: right"]17[/TD]
[TD="align: right"]131[/TD]
[TD="align: right"]0.02253182[/TD]
[TD="align: right"]0.542828[/TD]
[/TR]
[TR]
[TD="align: right"]41[/TD]
[TD="align: right"]131[/TD]
[TD="align: right"]0.02253182[/TD]
[TD="align: right"]0.565359[/TD]
[/TR]
[TR]
[TD="align: right"]22[/TD]
[TD="align: right"]130[/TD]
[TD="align: right"]0.022359821[/TD]
[TD="align: right"]0.587719[/TD]
[/TR]
[TR]
[TD="align: right"]44[/TD]
[TD="align: right"]130[/TD]
[TD="align: right"]0.022359821[/TD]
[TD="align: right"]0.610079[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD="align: right"]129[/TD]
[TD="align: right"]0.022187822[/TD]
[TD="align: right"]0.632267[/TD]
[/TR]
[TR]
[TD="align: right"]23[/TD]
[TD="align: right"]129[/TD]
[TD="align: right"]0.022187822[/TD]
[TD="align: right"]0.654455[/TD]
[/TR]
[TR]
[TD="align: right"]29[/TD]
[TD="align: right"]129[/TD]
[TD="align: right"]0.022187822[/TD]
[TD="align: right"]0.676643[/TD]
[/TR]
[TR]
[TD="align: right"]34[/TD]
[TD="align: right"]128[/TD]
[TD="align: right"]0.022015824[/TD]
[TD="align: right"]0.698658[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]0.021499828[/TD]
[TD="align: right"]0.720158[/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]0.021499828[/TD]
[TD="align: right"]0.741658[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]0.021499828[/TD]
[TD="align: right"]0.763158[/TD]
[/TR]
[TR]
[TD="align: right"]31[/TD]
[TD="align: right"]124[/TD]
[TD="align: right"]0.021327829[/TD]
[TD="align: right"]0.784486[/TD]
[/TR]
[TR]
[TD="align: right"]39[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]0.021155831[/TD]
[TD="align: right"]0.805642[/TD]
[/TR]
[TR]
[TD="align: right"]36[/TD]
[TD="align: right"]122[/TD]
[TD="align: right"]0.020983832[/TD]
[TD="align: right"]0.826625[/TD]
[/TR]
[TR]
[TD="align: right"]32[/TD]
[TD="align: right"]118[/TD]
[TD="align: right"]0.020295838[/TD]
[TD="align: right"]0.846921[/TD]
[/TR]
[TR]
[TD="align: right"]38[/TD]
[TD="align: right"]116[/TD]
[TD="align: right"]0.01995184[/TD]
[TD="align: right"]0.866873[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD="align: right"]115[/TD]
[TD="align: right"]0.019779842[/TD]
[TD="align: right"]0.886653[/TD]
[/TR]
[TR]
[TD="align: right"]18[/TD]
[TD="align: right"]113[/TD]
[TD="align: right"]0.019435845[/TD]
[TD="align: right"]0.906089[/TD]
[/TR]
[TR]
[TD="align: right"]30[/TD]
[TD="align: right"]113[/TD]
[TD="align: right"]0.019435845[/TD]
[TD="align: right"]0.925525[/TD]
[/TR]
[TR]
[TD="align: right"]42[/TD]
[TD="align: right"]111[/TD]
[TD="align: right"]0.019091847[/TD]
[TD="align: right"]0.944616[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD="align: right"]110[/TD]
[TD="align: right"]0.018919849[/TD]
[TD="align: right"]0.963536[/TD]
[/TR]
[TR]
[TD="align: right"]24[/TD]
[TD="align: right"]110[/TD]
[TD="align: right"]0.018919849[/TD]
[TD="align: right"]0.982456[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]102[/TD]
[TD="align: right"]0.01754386[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Sort by date Sort by votes
Code: 
Public Sub RandomN()
Dim colNames As New Collection
Const kPICKS = 7
Dim i As Integer, iCnt As Integer, iNum As Integer, iCol As Integer
Dim rStart As Range


On Error GoTo errRand


    'load the collection
Sheets("sheet1").Select
Range("A2").Select
While ActiveCell.Value <> ""
   colNames.Add ActiveCell.Value
   ActiveCell.Offset(1, 0).Select   'next row
Wend


  'post results
Sheets.Add
Set rStart = Range("A1")
    For i = 1 To kPICKS
      iCnt = colNames.Count
      'iNum = Int(iCnt * Rnd) + 1
      iNum = Int(1 + Rnd() * (iCnt - 1 + 1))
      
      ActiveCell.Value = colNames(iNum)
      colNames.Remove iNum
      
       ActiveCell.Offset(1, 0).Select   'next row
    Next
    
    iCol = iCol + 1
    rStart.Offset(0, iCol).Select
errRand:
Set rStart = Nothing
End Sub
 
Upvote 0
[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]
A​
[/td][td="bgcolor:#C0C0C0"]
B​
[/td][td="bgcolor:#C0C0C0"]
C​
[/td][td="bgcolor:#C0C0C0"]
D​
[/td][/tr][tr][td="bgcolor:#C0C0C0"]
1​
[/td][td="bgcolor:#F3F3F3"]
Number​
[/td][td="bgcolor:#F3F3F3"]
Freq​
[/td][td="bgcolor:#F3F3F3"]
Cumu​
[/td][td]
​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
2​
[/td][td]
33​
[/td][td]
149​
[/td][td="bgcolor:#E5E5E5"]
0​
[/td][td="bgcolor:#E5E5E5"]C2: =SUM(B$1:B1)/SUM($B$2:$B$46)[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
3​
[/td][td]
19​
[/td][td]
144​
[/td][td="bgcolor:#E5E5E5"]
0.025628​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
4​
[/td][td]
40​
[/td][td]
144​
[/td][td="bgcolor:#E5E5E5"]
0.050396​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
5​
[/td][td]
25​
[/td][td]
143​
[/td][td="bgcolor:#E5E5E5"]
0.075163​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
6​
[/td][td]
2​
[/td][td]
141​
[/td][td="bgcolor:#E5E5E5"]
0.099759​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
7​
[/td][td]
7​
[/td][td]
140​
[/td][td="bgcolor:#E5E5E5"]
0.124011​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
8​
[/td][td]
28​
[/td][td]
139​
[/td][td="bgcolor:#E5E5E5"]
0.148091​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
9​
[/td][td]
35​
[/td][td]
139​
[/td][td="bgcolor:#E5E5E5"]
0.171999​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
10​
[/td][td]
1​
[/td][td]
138​
[/td][td="bgcolor:#E5E5E5"]
0.195906​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
11​
[/td][td]
21​
[/td][td]
138​
[/td][td="bgcolor:#E5E5E5"]
0.219642​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
12​
[/td][td]
20​
[/td][td]
137​
[/td][td="bgcolor:#E5E5E5"]
0.243378​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
13​
[/td][td]
27​
[/td][td]
136​
[/td][td="bgcolor:#E5E5E5"]
0.266942​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
14​
[/td][td]
37​
[/td][td]
136​
[/td][td="bgcolor:#E5E5E5"]
0.290334​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
15​
[/td][td]
3​
[/td][td]
135​
[/td][td="bgcolor:#E5E5E5"]
0.313725​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
16​
[/td][td]
5​
[/td][td]
135​
[/td][td="bgcolor:#E5E5E5"]
0.336945​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
17​
[/td][td]
6​
[/td][td]
134​
[/td][td="bgcolor:#E5E5E5"]
0.360165​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
18​
[/td][td]
45​
[/td][td]
134​
[/td][td="bgcolor:#E5E5E5"]
0.383213​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
19​
[/td][td]
8​
[/td][td]
133​
[/td][td="bgcolor:#E5E5E5"]
0.406261​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
20​
[/td][td]
16​
[/td][td]
133​
[/td][td="bgcolor:#E5E5E5"]
0.429137​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
21​
[/td][td]
26​
[/td][td]
133​
[/td][td="bgcolor:#E5E5E5"]
0.452012​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
22​
[/td][td]
43​
[/td][td]
133​
[/td][td="bgcolor:#E5E5E5"]
0.474888​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
23​
[/td][td]
4​
[/td][td]
131​
[/td][td="bgcolor:#E5E5E5"]
0.497764​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
24​
[/td][td]
17​
[/td][td]
131​
[/td][td="bgcolor:#E5E5E5"]
0.520296​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
25​
[/td][td]
41​
[/td][td]
131​
[/td][td="bgcolor:#E5E5E5"]
0.542828​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
26​
[/td][td]
22​
[/td][td]
130​
[/td][td="bgcolor:#E5E5E5"]
0.565359​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
27​
[/td][td]
44​
[/td][td]
130​
[/td][td="bgcolor:#E5E5E5"]
0.587719​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
28​
[/td][td]
15​
[/td][td]
129​
[/td][td="bgcolor:#E5E5E5"]
0.610079​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
29​
[/td][td]
23​
[/td][td]
129​
[/td][td="bgcolor:#E5E5E5"]
0.632267​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
30​
[/td][td]
29​
[/td][td]
129​
[/td][td="bgcolor:#E5E5E5"]
0.654455​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
31​
[/td][td]
34​
[/td][td]
128​
[/td][td="bgcolor:#E5E5E5"]
0.676643​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
32​
[/td][td]
9​
[/td][td]
125​
[/td][td="bgcolor:#E5E5E5"]
0.698658​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
33​
[/td][td]
12​
[/td][td]
125​
[/td][td="bgcolor:#E5E5E5"]
0.720158​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
34​
[/td][td]
13​
[/td][td]
125​
[/td][td="bgcolor:#E5E5E5"]
0.741658​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
35​
[/td][td]
31​
[/td][td]
124​
[/td][td="bgcolor:#E5E5E5"]
0.763158​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
36​
[/td][td]
39​
[/td][td]
123​
[/td][td="bgcolor:#E5E5E5"]
0.784486​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
37​
[/td][td]
36​
[/td][td]
122​
[/td][td="bgcolor:#E5E5E5"]
0.805642​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
38​
[/td][td]
32​
[/td][td]
118​
[/td][td="bgcolor:#E5E5E5"]
0.826625​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
39​
[/td][td]
38​
[/td][td]
116​
[/td][td="bgcolor:#E5E5E5"]
0.846921​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
40​
[/td][td]
14​
[/td][td]
115​
[/td][td="bgcolor:#E5E5E5"]
0.866873​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
41​
[/td][td]
18​
[/td][td]
113​
[/td][td="bgcolor:#E5E5E5"]
0.886653​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
42​
[/td][td]
30​
[/td][td]
113​
[/td][td="bgcolor:#E5E5E5"]
0.906089​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
43​
[/td][td]
42​
[/td][td]
111​
[/td][td="bgcolor:#E5E5E5"]
0.925525​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
44​
[/td][td]
11​
[/td][td]
110​
[/td][td="bgcolor:#E5E5E5"]
0.944616​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
45​
[/td][td]
24​
[/td][td]
110​
[/td][td="bgcolor:#E5E5E5"]
0.963536​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
46​
[/td][td]
10​
[/td][td]
102​
[/td][td="bgcolor:#E5E5E5"]
0.982456​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
47​
[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
48​
[/td][td="bgcolor:#CCFFCC"]
19​
[/td][td][/td][td][/td][td="bgcolor:#CCFFCC"]A48: =INDEX($A$2:$A$46, MATCH(RAND(), $C$2:$C$46))[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
49​
[/td][td="bgcolor:#CCFFCC"]
7​
[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
50​
[/td][td="bgcolor:#CCFFCC"]
42​
[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
51​
[/td][td="bgcolor:#CCFFCC"]
17​
[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
52​
[/td][td="bgcolor:#CCFFCC"]
40​
[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
53​
[/td][td="bgcolor:#CCFFCC"]
41​
[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
54​
[/td][td="bgcolor:#CCFFCC"]
2​
[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
55​
[/td][td="bgcolor:#CCFFCC"]
18​
[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
56​
[/td][td="bgcolor:#CCFFCC"]
13​
[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
57​
[/td][td="bgcolor:#CCFFCC"]
37​
[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
58​
[/td][td="bgcolor:#CCFFCC"]
2​
[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
59​
[/td][td="bgcolor:#CCFFCC"]
45​
[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
60​
[/td][td="bgcolor:#CCFFCC"]
7​
[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
61​
[/td][td="bgcolor:#CCFFCC"]
32​
[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
62​
[/td][td="bgcolor:#CCFFCC"]
19​
[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
63​
[/td][td="bgcolor:#CCFFCC"]
37​
[/td][td][/td][td][/td][td][/td][/tr]
[/table]
 
Upvote 0
Thanks shg,

For some reason when I use INDEX($A$2:$A$46, MATCH(RAND(), $C$2:$C$46)) it seems to only come up with 10 each time - any ideas?
 
Upvote 0
File > Options > Formulas, > Calculation options > Workbook calculation, tick Automatic
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
how to random all numbers
Replies
7
Views
270
Fluff
Fluff
C
  • Question Question
Excel Formula to keep records of drawn cards
Replies
3
Views
280
Cquake
C
J
  • Solved
Auto count 1-12 with changing a a number (4-11) every 12 rows.
Replies
3
Views
194
Fluff
Fluff
S
  • Solved
Find the missing numbers from the range of numbers and filling the missing number in the cells below the last row
Replies
6
Views
598
sekar
S
S
  • Question Question
Counting the number of Baseball series per team
Replies
3
Views
460
James006
James006

Forum statistics

Threads
1,223,893
Messages
6,175,241
Members
452,622
Latest member
Laura_PinksBTHFT

Share this page

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top