Generate unique random numbers in Google Sheets
I want to generate in cells A1
, B1
, C1
, D1
, random numbers within the range 10 to 30. I have put in these cells the same function =RANDBETWEEN(10;30)
. However, random numbers sometimes have duplicate values, which I don’t want.