Excel Forum
Similar Content
Better Edit Excel Formulas in the Conditional Formatting Window or Name Manager
Tutorial: Excel quickie tutorial that will show you a great tip for working with formulas within th...
Delete Duplicate Values in All Versions of Excel
Tutorial: How to delete duplicate values from a data set in all versions of Excel. This includes Ex...
Return the Max Number from a Range That is Within a Minimum and Maximum Target Value in Excel - UDF
Macro: Return the highest number between two numbers that is in a range of cells with this UD...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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





Got a Question? Ask it Here in the Forum.