# How to display a given number of names randomly selected from a list

I have a list of 148 names in Column A. I need a function that would let a user enter in a number and use that number to return a list of names in column B or C. There can be repeats. So column B would prompt me with: "enter the number of names needed", and after I entered in the number, such as "4", below that prompt or in column C "4" names would be listed in different cells or even the same cell separated by commas. This workbook will eventually be embedded in a Wordpress.com site.

I looked online for some examples. This blog explains something similar:
http://datawiz.wordpress.com/2011/01...-from-a-sheet/

They prompt a user to look up the popularity of baby names. But since I don't know how to do very much in Excel, I can't figure out how to exactly apply his formulas to my problem.

Any suggestions?

I should also say that I already tried these formulas, which only give me one result in the cell that contains the formula:

``````=INDEX(\$A1:\$A148,RANDBETWEEN(1,COUNTA(\$A1:\$A148)),1)

=INDEX(A1:A148, RANDBETWEEN(1, 148))

=INDEX(Tanglelist, RANDBETWEEN(1, 148))
``````

I've asked this on other forums with no solution. But someone suggested this formula which I guess is a step in the right direction:

``````=IF(ROWS(B\$2:B2)>\$B\$1,"",INDEX(Tanglelist,RANDBETWEEN(1,ROWS(Tanglelist))))
``````
• The Wordpress link no longer exists. – fixer1234 Oct 24 '14 at 18:30
• Can you update the link? – RockPaperLizard Oct 24 '14 at 21:28

``````    =IF(ROW(c1)>\$B\$1,"",INDEX(\$A\$1:\$A\$148,RANDBETWEEN(1,148)))