Hi, could someone please help me with the next issue: I need to convert 5 min data into 30 min data. Thank you in advance. Alina
Hi, could someone please help me with the next issue: I need to convert 5 min data into 30 min data. Thank you in advance. Alina
Your data is actually in 15-minute increments - do you want to combine two rows into one?
Pete
Hi Pete,
Yes, mainly that's 'what I would want to do: have the average of 2 rows. Thank you
Hi there. to return the row headings, use this and copy down as far as needed:
=OFFSET($A$2,(ROWS($1:1)-1)*2,,,)
To return the averages, use this, copy across and down as far as needed:
=AVERAGE(OFFSET(B$2:B$3,(ROWS($1:1)-1)*2,))
Last edited by Glenn Kennedy; 08-17-2015 at 10:36 AM.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks