Extracting Data from a Table

I

Iceman

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!
 
G

Gord Dibben

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
 
I

Iceman

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.
 
I

Iceman

Hi Gord, I tried it but it only rolled back to row A63. SO I modified it to
=OFFSET($A$3,ROW()*30-90,) and it worked perfectly. Don't ask me how ....
just got lucky.

Any way, thanks for the prompt help. I appreciate it.
 
G

Gord Dibben

Where are you entering the formula? B1 or ?

I tested =OFFSET($A$3,ROW()*30-10*3,) in B1 with 1 to 900 starting in A3 and
returned

B1 1
B2 31
B3 61
B4 91
B5 121
etc.

Your fomula =OFFSET($A$3,ROW()*30-90,) starting in B1 returns

B1 #REF!
B2 #REF!
B3 1
B4 31
B5 61

"Perfectly" is a relative term it seems<g>


Gord
 
I

Iceman

I should have been a little more detailed.

My data is contained in columns A - D; row 3 - 9239.

I have placed the formula in column H - K.
 
Top