+ Reply to Thread
Results 1 to 3 of 3

Random Name Generator

  1. #1
    Registered User
    Join Date
    08-13-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    1

    Random Name Generator

    Every so often I have to randomly pick a few names from a list of individuals who have completed a survey. To do so, I have been pasting all of their names into excel, then, after checking how many names there are, setting a RANDBETWEEN function that selects between 1 and the number of individuals in the file. From there, I get a number and then plug that number into a cell, but add an A in front of it. It's not difficult, but I keep thinking that I should be able to automate that last step. So today I tried replacing that last bit, where I plug the number into a cell, by typing in the cell =A(Value(C3)) with C3, of course, being where I have my RANDBETWEEN function. I figured this would result in a cell that mimics my last step. Instead I get a #NAME error, which I imagine is because excel doesn't like multiplying non-numbers. Anyone have a solution that would make this work and help me automate this last step?

  2. #2
    Forum Contributor CheshireCat's Avatar
    Join Date
    10-11-2011
    Location
    Victoria, Canada
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    258

    Re: Random Name Generator

    Try this:

    Please Login or Register  to view this content.
    Docendo discimus.

  3. #3
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Random Name Generator

    You could use INDEX, here for one formula to give a random name, which will adjust dynamically if you add or delete names (should be continuous, though)

    E.g. assuming list of names starts at A2 and goes as far as A1000 at most then try

    =INDEX(A2:A1000,RANDBETWEEN(1,COUNTA(A2:A1000)))
    Audere est facere

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1