In this Excel VBA tutorial lesson, you will learn how to create a loop formula in Excel without using macro or VBA.
It is very common to create the required loops in Excel vba like if loop, do while loop, do until loop, for loop, while wend loop for different purposes.
But here we will create a similar effect in Excel using formulas.
Excel loop formula
In any Excel file name the sheet as "testsheet" and "result sheet" and in cell A1 of "result sheet" white formula:
=IF('testsheet'!C1 <= 99,'testsheet'!A1,"")
Copy this until row 40.
Now in cell B1 write formula: =A1
Now in cell B2 write: =B1 & A2
Looping in Excel without Vba code
Copy this till B40. We will get the following results:
It worked the same as for loop in but without Vba code involved.