AICT 1 15F‎ > ‎Spreadsheets‎ > ‎

Random Name Generator

In Excel or Google Drive Sheets, create a list of
  1. 25-50 first names (boys' or girls', your choice)
  2. and 25-50 last name/family names.
  3. Each list should be in its own column (not row).

Your two lists should be equal in length.

You are going to use the RANDBETWEEN function to generate random numbers.

  • Functions do some complicated math for us so we don't have to.
  • All functions must start with and = (equals) sign.
  • If the function shows a range of numbers, you generally have the numbers separated by a comma.
  • For this function, we're going to generate a random number between 1 and 10,000.
  • In the first cell in the column next to the first names, type in =Randbetween(1,10000)
  • Copy that formula to the cells below it.
    • You can do this with Control C, and then Control V, or by pulling on the little tab in the bottom right corner of the cell you want to copy.
  • Sort the data according to the random numbers generated.
    • The name that appears at the top is your random name for your story character/dog/new baby, etc.