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];