![]() Otherwise you can use the other “old method” explained in the post below. You will need to be on the latest version of Office 365 for this to work. ![]() I have added a section below that explains the formula. Update January 20, 2020: We can now solve this with a formula using a few of the new Dynamic Array Functions, SORTBY, SEQUENCE, and RANDARRAY. We can use the RANDBETWEEN function to create random numbers between a certain range, say 1 and 100, but there is nothing in the function to prevent duplicate numbers from being created in the range. Unfortunately, there is no function built into Excel that will create a list of unique random whole numbers (see update below). My friend and fellow blogger, George Mount, posted a question on Facebook yesterday about creating a list of random non-repeating numbers. Bottom line: Learn how to create a list of unique random numbers with no duplicates or repeats.
0 Comments
Leave a Reply. |