Thanks, it works.
How can I make sure that if I repeat the command for x rows I will not
get twice the same string (being same numbers, even if different
order)?
Thank you!
On Sep 20, 9:19 am, Aindril De wrote:
> Hi Giorgio,
>
> Looks like the issue was here:
>
> *Function RandLotto(Bottom
Hi Giorgio,
Looks like the issue was here:
*Function RandLotto(Bottom As Integer, Top As Integer, _
Amount As Integer) As String*
*
*
*When you copy paste the above it does not work.*
*
*
*Please replace the above lines with:*
*Function RandLotto(Bottom As Integer, Top A
Thank you Andy.
I insert the module but I can't see it in the list of functions
Anyhow, when I try to run it, I get the following error:
"Compile Error:
Expected: line number or label or statement or end of statement".
Any clue what is it about ?
Thank you!
On Sep 18, 6:25 am, Aindril De
Hi Giorgio,
Use the following UDF.
*Function RandLotto(Bottom As Integer, Top As Integer, _
Amount As Integer) As String*
Dim iArr As Variant
Dim i As Integer
Dim r As Integer
Dim temp As Integer
Application.Volatile
ReDim iArr(Bottom To Top)
All,
I need to build an excel that generates X unique series of 5 random
numbers, lottery style (no repetition in the same series and no
repetition across the series).
I know the function RANDBETWEEN, but how can I include the "no
repetition"?
Thank you,
G
--
