S
Steve Bedard
How do you randomly generate numbers from 1 to 84 without duplicates in Excel
2007?
2007?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
×
מיכ×ל (מיקי) ×בידן
1) Download and Install "MoreFunc" add-in.
http://www.download.com/Morefunc/3000-2077_4-10423159.html
2) In cell A1 type: =MRAND(,1,84) and copy down all the way to A84 (incl.)
Micky
http://www.download.com/Morefunc/3000-2077_4-10423159.html
2) In cell A1 type: =MRAND(,1,84) and copy down all the way to A84 (incl.)
Micky
N
Niek Otten
M
Mike H
Hi,
the question isn't clear but try this. Select the cells you want the numbers
in and run this code. Because you are in the range 1 to 84 you mest selevt 84
cells or less
Sub Unique_Rands()
Dim FillRange As Range
Set FillRange = Selection
For Each c In FillRange
Do
c.Value = Int((84 * Rnd) + 1)
Loop Until WorksheetFunction.CountIf(FillRange, c.Value) < 2
Next
End Sub
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
the question isn't clear but try this. Select the cells you want the numbers
in and run this code. Because you are in the range 1 to 84 you mest selevt 84
cells or less
Sub Unique_Rands()
Dim FillRange As Range
Set FillRange = Selection
For Each c In FillRange
Do
c.Value = Int((84 * Rnd) + 1)
Loop Until WorksheetFunction.CountIf(FillRange, c.Value) < 2
Next
End Sub
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
×
מיכ×ל (מיקי) ×בידן
Well..., I don't know how much of a "gambler" you are - but as a "Gimmick"
you are invited to try the proposal in the picture.
Any cell - in range F1:F84 must be blank.
An "X" points that that value was generated more than once.
Cells A1, B1 and F1 should be copied down all the way until row 84.
http://img717.imageshack.us/img717/5083/nonamesi.png
Micky
you are invited to try the proposal in the picture.
Any cell - in range F1:F84 must be blank.
An "X" points that that value was generated more than once.
Cells A1, B1 and F1 should be copied down all the way until row 84.
http://img717.imageshack.us/img717/5083/nonamesi.png
Micky