Remember Me?

#1
Posted to microsoft.public.excel.newusers
 external usenet poster Posts: 457
formula to convert 15 minute to hourly data

This formula should work:
=AVERAGE(OFFSET(\$B\$2,(ROW(A1)-1)*3,,4))
this averages range B2:B5
copying down will automatically change it to:
=AVERAGE(OFFSET(\$B\$2,(ROW(A2)-1)*3,,4))
which averages range B5:B8

--
Best Regards,

Luke M
"penny" wrote in message news:...
Message-ID:
X-Mailer: http://www.umailcampaign.com, ip log:68.45.155.120
Newsgroups: microsoft.public.excel.newusers
NNTP-Posting-Host: 22.bb.5446.static.theplanet.com 70.84.187.34
Path: TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl!newspe.c om
Lines: 1
Xref: TK2MSFTNGP01.phx.gbl microsoft.public.excel.newusers:69083

Hi,
I tried to use this and it works but how can I get the B2:B5 range to
begin
at the ending cell (i.e. B5) and calculate each subsequent range
accordingly.
My problem is that if I am averaging every 15 minute data for each hour I
would like for it to calculate B2:B5, B5:B8, B8:B11,etc...Any help would
be
much appreciated. Thank you for taking the time to look at this.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Emily New Users to Excel 8 April 3rd 23 02:12 PM Ron Excel Worksheet Functions 11 January 19th 17 03:29 PM kippers Excel Discussion (Misc queries) 5 February 1st 07 10:27 AM nobbyknownowt Excel Discussion (Misc queries) 2 December 21st 06 07:37 PM Jboerding Excel Discussion (Misc queries) 2 July 6th 05 11:30 PM

All times are GMT +1. The time now is 09:24 PM.