Real random list

You’d have to either use arrayformula or manually drag the closest cell to duplicate the formula