Question: How do I create a repeating list of numbers from 1 to Nth value? In my case from 1 to 4 repeating?

Answer: Nth value in D1.

Formula in A1: =(IF(MOD((ROW()-ROW(List_start)+1)/$D$1, 1)=0, 1, MOD((ROW()-ROW(List_start)+1)/$D$1, 1)))*$D$1 Copy formula down to A20.

Named ranges
List_start A1
What is named ranges?

Type a  value in D4 and watch the list automatically change.

How to customize this formula to your workbook
Change the named range to the starting reference of your list

Download excel example file
create-a-numbered-list.xls
(Excel 97-2003 Workbook *.xls)

Functions in this article:

IF(logical_test;[value_if:true];[value_if_false])
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE

ROW(reference) returns the rownumber of a reference

MOD(number, divisor) returns the remainder after a number is divided by a divisor

Related posts:

1. Create and sort distinct list by adjacent cell value size
2. Create a list of all numbers or text in a column in excel
3. How to create a random list of unique numbers in excel
4. Create a drop down list containing only unique distinct alphabetically sorted text values using excel array formula
5. Create a unique distinct text list from a range containing both numerical and text values in excel
6. Extract numbers and text from a range using array formula in excel
7. Identify missing numbers in a range in excel
8. Filter a column and create a new unique list sorted from A to Z using array formula in excel
9. Create unique distinct list sorted based on text length using array formula in excel
10. Create unique list from two columns