Main Profile

At A Glance

Mr Excel & excelisfun Trick 11: Randomly Select A Name

See Mr Excel and excelisfun create a formula that will randomly select a name from a list of names without having the list of names sitting in cells. See the functions INDEX, RANDBETWEEN, INT, RAND and see how to convert a list in cells (range) to a list that can be placed in a formula (array with array syntax). See how to store a list of values in memory with array syntax and a Named Constant (Define Names Name Manager). Related video: Dueling: Random Name - 1020 - Learn Excel from MrExcel
Length: 05:12

Contact

Questions about Mr Excel & excelisfun Trick 11: Randomly Select A Name

Want more info about Mr Excel & excelisfun Trick 11: Randomly Select A Name? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question