DESCRIPTION
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).
WORKBOOKS
Download “Dueling-Excel-011-020” Dueling-Excel-011-020.zip – Downloaded 87 times – 171 KB
Leave a Reply
You must be logged in to post a comment.