Question: How to automatically create a numbered list?

Answer:

1. Type =IF(C1="","",COUNTA($C$1:C1)&".") in cell A1.
2. Copy cell A1 to the next 20 cells in column A.
3. As you type more values in column C, column A will automatically create a numbered list.
4. If cell in column c is empty, cell in column A will be empty.Column B shows the formula.

COUNTA(value1;[value2];

Related posts:

Create a dynamic named range in excel

How to automatically create a unique distinct list and remove blanks

Create a repeating list of numbers from 1 to Nth value

How to create a dynamic pivot table and refresh automatically in excel

Create a drop down list containing alphabetically sorted values in excel