Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Thus, you may want to copy the generated items and use 'paste . Click OK after this. Advanced Excel Exercises Finally, the INDEX function will extract the value according to the number. In the example shown, the formula in G7 is: Note: this formula uses the named range "data" (B5:E104) for readability and convenience. as column heading, and then type sequence numbers into following cells as above screenshot: Step 3: Fill specified cells randomly from the given list: (1) In a blank cell enter the formula =RANDBETWEEN (1,15), and . Site design / logo 2022 Stack Exchange Inc; user contributions licensed under CC BY-SA. A delimiter is a character such as a comma or space that separates the items. This function doesn't use any parameter and returns a decimal value between 0 and 1.