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.

Subscribe to my mailing list.

Leave a Reply

%d bloggers like this: