Try this

In B1 enter =OFFSET($A$3,ROW()*30-10*3,)


Gord


On Wed, 28 Nov 2007 08:45:03 -0800, Iceman
wrote:

Thanks Gord, it does work. However, one problem. it seems to want to start at
row A90 instead of A3 (the start of the data in the column). Any idea how to
fix this.

Thanks again in advance.

"Gord Dibben" wrote:

Assuming your data is in Column A

In B1 enter =INDIRECT("A"&ROW()*30)

Drag/copy down as far as you wish.


Gord Dibben MS Excel MVP


On Tue, 27 Nov 2007 12:18:01 -0800, Iceman
wrote:

Here's the situation.
I have a table of information (temperature readings) taken every minutefor 7
days, but I don't need the information from every minute, just every 30
minutes. How do I go about setting up a table which will only read and
display the values for only the 30 minute intervals?

Thanks in advance!