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))))
```