I have a pretty hard Excel question I'm seeking a solution for. I have one Excel file with two tabs.

- Tab1: raw data
- Tab2: raw data processed and grouped for a nice lay-out for printing purposes

Contents Tab1:

```
A1 = 1
A2 = 2
A3 = 3
A4 = 4
A5 = 5
```

Contents Tab2:

```
A1 = Result
A2 ='TAB1'!A1 (a formula with reference to A1 in Tab1)
```

Wen I'm selecting A1 and A2 in Tab2 to drag/copy I get the following result:

```
A1 = Result
A2 = 1
A3 = Result
A4 = 3
A5 = Result
A6 = 5
```

The problem: when I'm selecting A1 and A2 and drag/copy, the formula thinks he has to increment with 2. There has to be an increment by 1! The desired result is:

```
A1 = Resultaat
A2 = 1
A3 = Resultaat
A4 = 2
A5 = Resultaat
A6 = 3
A7 = Resultaat
A8 = 4
A9 = Resultaat
A10 = 5
```

Anyone has ideas or suggestion. This is just a simpel projection. My actual Excel has 21 rows so the increment is 21 wherever this has to be 1!

`INDIRECT()`

function to make correct reference, and`ROW()/2`

to build it. – Akina Feb 12 at 11:45