Type the formula that draws one random ticker from a named range of index constituents.
Type the formula that draws one random ticker from a named range of index constituents.
Answer
=INDEX(Tickers,RANDBETWEEN(1,COUNTA(Tickers)))
COUNTA sizes the range, RANDBETWEEN picks a row, INDEX returns the ticker. Copy the result as a value at once — the formula re-draws on every recalculation.
OSC ATS list and Cboe Canada recognition (osc.ca); CSE about page (thecse.com); Cboe Canada (cboe.com/ca); Montréal Exchange equity-options specs (m-x.ca) — observed 2026-09-17