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

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
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
280
Fluff
Fluff
C
  • Question Question
Excel Formula to keep records of drawn cards
Replies
3
Views
297
Cquake
C
J
  • Solved
Auto count 1-12 with changing a a number (4-11) every 12 rows.
Replies
3
Views
195
Fluff
Fluff
C
  • Locked
  • Question Question
Tex Split
Replies
4
Views
93
RoryA
RoryA
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
605
sekar
S

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

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