Generate unique random number that doesnt exist

my Goal is to generate a random number that is unique in a google sheet column. Can i use a repeater to continuously repeat until it is unique, how?

You can use a Search Module to return all the current values in the column first.

Then, create an array of numbers excluding those values.

Then, shuffle and pick one.

samliewrequest private consultation

Join the Make Fans Discord server to chat with other makers!

3 Likes