Remember Me?

#1
May 20th 10, 04:12 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Feb 2010 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 Ron Excel Worksheet Functions 11 January 19th 17 04:29 PM Emily New Users to Excel 7 September 22nd 16 10:17 AM kippers Excel Discussion (Misc queries) 5 February 1st 07 11:27 AM nobbyknownowt Excel Discussion (Misc queries) 2 December 21st 06 08:37 PM Jboerding Excel Discussion (Misc queries) 2 July 6th 05 11:30 PM

All times are GMT +1. The time now is 08:59 AM.