Try the below and then you can work it out...(every 3rd cell)

Enter few values in A5, A8, A11, A14 etc;
In cell B5 enter the formula =A5

In B6 enter the below formula and copy down
= INDIRECT("A"&ROW($B$5)+(ROW()-ROW($B$5))*3)


--
If this post helps click Yes
---------------
Jacob Skaria


"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