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:
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.
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: