Picking a Random Name from given list

Today we will discuss about random list i.e. how to look for a random name in the given excel list.

Here below we have a excel list from range A1:A14, and in range B2 there is value "Vimal" but the fact is cell B2 has a formula i.e. INDEX and RANDBETWEEN both formula has separate solution like Index has a list of names and randbetween has to pick any name from the give list so below is the example and we can understand in a very easy way.

Here in this example we are watching in this list A1:A14 it has 14 names so if we want  any name from this list, so put a randbetween formula, randbetween formula look for any no. value from the given range. And what index function does, it provides a list range as an array like range A1:A14

so simple index function provides a range and randbetween look for any no. value i.e. name from the list. So easily we can get the random no. or name from the given list.

Thanks

Narendra