List data

[mdmackillop]

I'm sure it's here but I can't find it.
Looking for a formula to show one below the other a list of data in one column in spaced rows ie Rows 1,8,17,25 contain data, I need to have the values in a block on another sheet.

[Jan Karel Pieterse]

OFFSET function or INDEX function with 8*ROW() as one of the key arguments? That is, if they are evenly spaced, which your example is not :-)

[mdmackillop]

Data is not evenly spaced. I'm thinking INDEX SMALL, but can't quite get it!

[mdmackillop]

Got it at last (ROW()-2 change to suit)

=INDEX(Rng,SMALL(IF(Rng<>"",ROW(Rng)),ROW()-2),1)