Excel Forum

Excel Magic Trick 373: Randomize with No Repeats (Numbers or Words)

See how to select 3 numbers from 50 with no repeats. See how to select 3 names from a list of 10 with no repeats. See the MRAND, INDEX and COUNTA functions.
Excel Magic Trick 276 MoreFunc Excel add-in 66 New functions

Take Sample without repeats

Got a Question? Ask it Here in the Forum.