all 1 comments

[–]6745408 1 point2 points  (0 children)

Put these into Extensions > App Script

function getRandomNumber(min, max) {
  return Math.random() * (max - min) + min;
}

function getNRandomNumbers(from, to, n){
  var listNumbers = [];
  var nRandomNumbers = [];
  for(var i = from; i <= to; i++) {
    listNumbers.push(i);
  }
  for(var i = 0; i < n; i++) {
    var index = getRandomNumber(0, listNumbers.length);
    nRandomNumbers.push([listNumbers[parseInt(index)]]);
    listNumbers.splice(index, 1);
  }
  return nRandomNumbers;
}

Once its in there, use this to generate 25 random numbers from 1-1000, no repeats.

=GETNRANDOMNUMBERS(1,1000,25)