I need to generate 5 random numbers
from 1 to 15 in cells a3 to a7 with
no duplicates.
I currently use the code =RANDBETWEEN(1,15)
in each cell which works great, but it can generate a duplicate number.
Is there code I can add to =RANDBETWEEN(1,15)
That would not create a duplicate number
in cells a3 to a7?
Or possible VB code to do the same?
Thanks
from 1 to 15 in cells a3 to a7 with
no duplicates.
I currently use the code =RANDBETWEEN(1,15)
in each cell which works great, but it can generate a duplicate number.
Is there code I can add to =RANDBETWEEN(1,15)
That would not create a duplicate number
in cells a3 to a7?
Or possible VB code to do the same?
Thanks