Excel Guides

Generating Unique Sequential Numbers in Excel

There are a few ways to generate unique sequential numbers in Excel. One way is to use the RANDBETWEEN function. This function will return a random number between the two numbers that you specify. For example, if you wanted to generate a unique sequential number between 1 and 100, you would use the following formula:

=RANDBETWEEN(1,100)

Another way to generate unique sequential numbers is to use the RANK function. This function will return the rank of a number within a list of numbers. For example, if you have a list of numbers in cells A1 through A100 and you want to generate a unique sequential number for each cell, you would use the following formula in cell B1 and then copy it down to cell B100:

=RANK(A1,A$1:A$100)

You can also use the ROW function to generate unique sequential numbers. This function will return the row number of a cell. For example, if you have a list of numbers in cells A1 through A100 and you want to generate a unique sequential number for each cell, you would use the following formula in cell B1 and then copy it down to cell B100:

=ROW()-ROW(A$1)

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.