Then wrap this with the INDEX function to select an item in column A : =INDEX(A1:A10,RANDBETWEEN(1,10),1) The top bound in your RANDBETWEEN should match the number of rows in your range (10 in this case).
— Ben Collins (@benlcollins) Sep 14, 2021
from Twitter https://twitter.com/benlcollins
September 15, 2021 at 12:00AM
No comments:
Post a Comment