Extracting Data from a Table

  • Thread starter Thread starter Iceman
  • Start date Start date
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!
 
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
 
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.
 
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.
 
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 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.
 
Back
Top