How to return a set number of consecutive numbers in Excel. By combining ROW() and ROUND() with a couple of input values, you can create a very flexible consecutive numbering function.

Type the next consecutive number below the last number in your list. For example, if cell G50 contained "120," type "121." Click and drag your mouse across both cells to select them.

However, Excel's random number functions are volatile, meaning they change constantly. In this article, I'll show you how to generate and fix random numbers and remove duplicates.