UNIQUE function not as expected

Trying to generate an 11x4 array of unique integers. UNIQUE(RANDBETWEEN(1,44)) will generate the array but repeats numbers. Why doesn't UNIQUE work here?

excel

Formulas and Functions

PeterBartholomew1
Aug 20, 2021
JoeNews
A standard way of getting unique values is to generate them first and then randomise their order.
= LET( index, SEQUENCE(44), random, RANDARRAY(44), seq, SEQUENCE(11,4), sorted, SORTBY(index, random), INDEX(sorted, seq) )

PeterBartholomew1

Silver Contributor

Aug 20, 2021

JoeNews

A standard way of getting unique values is to generate them first and then randomise their order.

= LET(
    index,  SEQUENCE(44),
    random, RANDARRAY(44),
    seq,    SEQUENCE(11,4),
    sorted, SORTBY(index, random),
    INDEX(sorted, seq)
  )

JoeNews

Copper Contributor

Aug 22, 2021

Thank you Peter. Works beautifully.

Forum Discussion

UNIQUE function not as expected

Resources