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)
``````

### Excel

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