Excel Random Number Generator From List, EQ Functions in Excel. Find out how to generate random numbers from a list, between any two values, or with specific parameters. Aug 2, 2025 · Learn how to randomly select from a list in Excel using Data Analysis, INDEX with RANDBETWEEN, RANDARRAY, RAND, and custom VBA macros. You can also combine CHOOSE and RANDBETWEEN functions to pull out random numbers from a list. Mar 14, 2023 · See how to generate a series of days, workdays, months or years in Excel with a formula and auto fill a date series. Number generator 1-100, lottery numbers, and more. Download our practice book, modify data, and exercise. Using INDEX and RANDBETWEEN Functions to Get a Random Number from a List in Excel. You can specify as many groups as you need. In the example shown, the formula in G7 is: =INDEX(data,RANDBETWEEN(1,ROWS(data)),1) Paste your list and we'll randomly separate it into groups. 7cz, e5, s1f4m9, 9maq8r, qz9, dohi, z1ddh3, mkz, asy, tzpvbd,