Relative Content

Tag Archive for google-sheetsrandomgoogle-sheets-formula

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.