# How to loop in excel without VBA or macros?

###### Posted By: Anonymous

Is it possible to iterate (loop) a group of rows in Excel without VBA or macros installed? A web search didn’t yield anything helpful.

```
=IF('testsheet'!$C$1 <= 99,'testsheet'!$A$1,"") &
IF('testsheet'!$C$2 <= 99, 'testsheet'!$A$2,"") &
IF('testsheet'!$C$3 <= 99, 'testsheet'!$A$3,"") &
... and so on through !$C$40, !$A$40 ...
```

As it is, I’ll have to repeat the above code 40 times in each cell and I have over 200 cells which need the code.

I’m pretty good with PHP/SQL, but just learning Excel.

## Solution

The way to get the results of your formula would be to start in a new sheet.

In cell A1 put the formula

```
=IF('testsheet'!C1 <= 99,'testsheet'!A1,"")
```

Copy that cell down to row 40

In cell B1 put the formula

```
=A1
```

In cell B2 put the formula

```
=B1 & A2
```

Copy that cell down to row 40.

The value you want is now in that column in row 40.

Not really the answer you want, but that is the fastest way to get things done excel wise without creating a custom formula that takes in a range and makes the calculation (which would be more fun to do).

###### Answered By: Anonymous

Disclaimer: This content is shared under creative common license cc-by-sa 3.0. It is generated from StackExchange Website Network.