Random Name / text picker – with Index function

Hello all. We have already seen random name picker here – there we used the CHOOSE function. Let’s see how to use generate random name (text) using the INDEX function. Index function returns the value of the cell at an intersection of specified row and column. With Index as the base, we shall see howContinue reading “Random Name / text picker – with Index function”

How to create a random name picker

Hello All. Here is a quick step by step guide on how to create random name picker in excel. This is absolutely dynamic and random. We shall be using Choose & Randbetween functions to achieve this. First let’s see the syntax for the choose function =Choose(index_num, value1, value2,… value 254) Here the index number willContinue reading “How to create a random name picker”