From what I understand, there is no built-in function in Google Sheets that allows you to set a seed for RAND() or RANDBETWEEN().
My goal is to create a list of psuedo-random integers, within a range, using a function that will produce different (though, not necessarily unique) values based on:
- Which cell is running the function
- And the value in a second cell that contains a seed of my choosing
I need it to produce the same value every time the function is run in a particular cell, with a particular seed.
What is the simplest way to achieve this, so that someone who isn t me and has no programming knowledge can easily use the formula in other cells, as they need to?