This means that if you add an extra column next to your names and assign caps ceiling values to each, you will effectively be able to create weighted probabilities. Try adding ceilings between 1-100 to all names and try the following: =INDEX(A:A, MATCH(RANDBETWEEN(1,100),B:B,1)) This is assuming your names are in A and your ceilings are in B. .

generate random names in excel