0

Basically, I'm just trying to figure out how to make a cell pull a random cell's value within a range at random when the page loads.

For example, have cell A1 pull a cell at random from range B1:B20 and refresh when the page is refreshed.

0

=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))

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.