Question: how to create a loop formula in excel?
Answer: To make a loop of numbers 1-5 in column A: Enter "=A1" in cell A6. As you drag down, it will automatically be "=A2" in cell A7, etc. because of the way that Excel does things.