In this blog post, we look at how to pick a name at random from a list. There are many reasons you may need this kind of random selection from a list.
It may be a neat way of deciding who is next to do the washing up, or to make a cup of tea :). Or it is useful for randomly drawing teams for a knockout cup competition.
To perform this random selection, we are going to use two different functions together. They are INDEX and RANDBETWEEN.