Use INDEX, RANDBETWEEN, and ROWS to randomly select a value from a static or dynamic Excel range without VBA.