Generate unique random numbers in Google Sheets

  Kiến thức lập trình

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.

So that the random numbers appearing at the same time in these 4 boxes do not overlap, what should I do?

LEAVE A COMMENT