If i didn't miss anything
on another worksheet in A1

=OFFSET(Sheet1!$A$5,3*(ROW()-1),)

then copy/drag down



On 21 Maj, 14:26, GD wrote:
Hi, reasonably simple one...I have some data in cells within one column but
separated by rows each time, so for example the figures are in BI5, BI8,
BI11, BI12 etc

On another worksheet I want to condense this data - so essentially get rid
of the gaps in between so it would read BI5, BI6, BI7 etc - the sample size
is so large removing rows would be extremely time consuming, all i want
really is a formula that references the figure, and as I copy it down in the
new column it will reference every 3rd cell in the range