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. (https://lnkd.in/efY-fSQD)

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. (https://lnkd.in/e_nkB2yw)

𝗙𝘂𝗻𝗰𝘁𝗶𝗼𝗻 𝗦𝘆𝗻𝘁𝗮𝘅

RANDUNIQUE(𝗿𝗼𝘄𝘀, 𝗺𝗶𝗻, 𝗺𝗮𝘅)

• 𝗿𝗼𝘄𝘀 — the number of rows in the returned array
• 𝗺𝗶𝗻 — the minimum number you would like returned
• 𝗺𝗮𝘅 — the maximum number you would like returned

GitHub Gist URL — https://lnkd.in/eedeGcZu.