I have a list of unique words. I would like to populate some of them into a row range but every cell in the range would be filled in without duplicates.
=INDEX(A2:A120,UNIQUE(RANDARRAY(1,F1,1,ROWS(A2:A100),TRUE),TRUE))
so far I have this working formula, which provides the random unique values, however sometimes not all cells in the range filled in (because of the deleted duplicates). I saw solutions they use sequence to so solve this problem, but for mee it does not really work as it drops Calc! error.
=INDEX(A2:A120,UNIQUE(RANDARRAY(1,F1,1,ROWS(A2:A100),TRUE),TRUE), SEQUENCE(0,2))

Formula in C1:
=TOROW(UNIQUE(SORTBY(A1:A10,RANDARRAY(ROWS(A1:A10)))))
In this example formula takes 10 random values of 15 values existing unique list.
=TOROW(INDEX(A2:A16,TAKE(SORTBY(SEQUENCE(ROWS(A2:A16)),RANDARRAY(ROWS(A2:A16))),F1)))
Result:

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With