SELECTONE

SELECTONE(range)
Returns one random item from a list of values.
It returned one randomly selected cell value from the specified range.
Works with vertical or horizontal ranges
Ignores blank cells
Returns text, numbers, or errors exactly as stored
Recalculates on every sheet calculation


=LET( 
    vals, FILTER(range, range<>""),
    INDEX(vals, RANDBETWEEN(1, ROWS(vals)))
)





© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext