Randomizer I'm trying to select a random name from a list in Excel but I cannot figure out how to do it in Microsoft 365. HELP! Need it ASAP! mstaples929 Let's say your list is in A2:A50, i.e. it contains 49 names. The formula =INDEX(A2:A50,RANDBETWEEN(1,49)) will return ...
ThepwrRANDFROMRANGEPowerUp function returns the value in a randomly selected cell from the range provided. PowerUp Syntax pwrRANDFROMRANGE(range) ThepwrRANDFROMRANGEPowerUp function has the following arguments: range– Required. This is the range of cells from which to select the random cell. R...
Randomizer I'm trying to select a random name from a list in Excel but I cannot figure out how to do it in Microsoft 365. HELP! Need it ASAP! mstaples929 Let's say your list is in A2:A50, i.e. it contains 49 names. The formula =INDEX(A2:A50,RANDBETWEEN(1,49)) will return ...