Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =ARRAYFORMULA(ARRAY_CONSTRAIN(VLOOKUP(QUERY({ROW(B1:B20),
- RANDBETWEEN(ROW(B1:B20)^0, 999^99)}, "select Col1 order by Col2"),
- {ROW(B1:B20), B1:B20}, 2, 0), 1, 1))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement