Generating Unique Random Numbers in R For Excel

Never listen to the Excel haters — it’s not going anywhere. Choosing to use R “instead of” Excel is like naming a favorite child! Each has its advantages, and a savvy analyst is able to use them in tandem. Here’s an example of using R to make up for an Excel shortcoming. DO NOT BE […]

Generate Unique, Non-Repeating List of Numbers in Excel with RAND and RANK

Download the exercise file here. Let’s say you need to come up with a seating chart. Using RANDBETWEEN, you may get duplicate entries for the same number, or missing numbers. Using RAND in conjunction with RANK will get you a list of unique, non-repeating numbers in Excel.