How to loop without VBA or macros?

In this article we will learn to create a loop in Excel without using macro or VBA.

It is very common to create the required loops in Excel vba like if loop, for loop, while wend loop for different purposes.

But here we will create the similar effect in Excel using formulas. 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 till row 40

copy formula

Now in cell B1 write formula: =A1

write formula

Now in cell B2 write: =B1 & A2

write formula column b

 

Copy this till B40. We will get the following results:

loop wothout vba code