Loading...

Mr Excel & excelisfun Trick 11: Randomly Select A Name

31,783 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Uploaded on May 21, 2009

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

Loading...

Advertisement
to add this to Watch Later

Add to

Loading playlists...