copy a cell reference down starting at row x and then every nth row

[Morphies]

Hi All,

I'm trying to tidy up some data into another tab.

The source data is infinitely lings I wanted to create a formula to tidy the data into a new sheet..

The data starts on row 5 every time and thenext set of data is every 10 rows thereafter.

I’m guessing I need to use the offset, but cantget it to work…

 =OFFSET(Sheet1!$J$5,(ROW()-1)*10,0)

This gives me the reference in J15 but I needit to start at J5 then go down to J15, J25, J30 etc

Any clues?

Thanks,

 

[Joe4]

My guess is that you are putting this first formula on row 2.
If so, subtract 2, not 1, from ROW(), i.e.

[FONT=Arial]=OFFSET(Sheet1!$J$5,(ROW()-[COLOR=#ff0000][B]2[/B][/COLOR])*10,0)[/FONT]

 

[Morphies]

awesome, thanks.

 

[Joe4]

You are welcome.
Basically, you want to use the row number of the first row you are placing this formula in.