excel Like 0 Reply View Full Discussion (3 Replies) HansVogelaar MVPApr 02, 2021 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 retur
I am having an issue generating an assignment randomizer on Excel. Only certain people are trained on a certain assignment. With 11 Assignments I want it to be able to choose randomly from 15+ people without one person getting 2 assignments and the right people who are trained to do the as...
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 a random name from the list. Each time Excel recalculates formulas a new name will be returned. Like 0 Reply mstaples929 Copper Contributor to HansVogelaar Apr 02...
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 ...
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 ...
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 a random name from the list. Each time Excel recalculates formulas a new name will be returned. Like 0 Reply mstaples929 Copper Contributor to HansVogelaar Apr 02...