RANDUNIQUE

Introducing RANDUNIQUE — for when you want to return an array of unique random numbers.

Three weeks ago, I showed a couple of methods of how to do this with formulas.

After a few refinements, those formulas have now been packaged into a single function. That’s thanks to LAMBDA, which finally went mainstream the other day. It was joined by Advanced Formula Environment — an add-in giving us the formula editor we’ve been longing for.

Function Syntax

RANDUNIQUE(rows, min, max)

• rows — the number of rows in the returned array
• min — the minimum number you would like returned
• max — the maximum number you would like returned

RANDUNIQUE

RANDUNIQUE. GitHub Gist: instantly share code, notes, and snippets.

Read More

gist.github.com