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…
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,
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…
Rich (BB code):
Rich (BB code):
=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,