Just split them into different columns? :shrug:

ive got to take the average of 24 cells, 365 times lol. no manual stuff pls
unless i dont follow what youre saying

You can't just do the formula once, then go on the box and just drag is all the way to the right to copy it?

the temperatures are listed in a column. when i drag AVERAGE(B2:B25) down, it doesnt start at a new day, it starts at the 2nd hour of the first day to the 2nd hour to the 2nd day

what i need is =AVERAGE(B26:49) so its first hour of second day to 24th hour of second day

better? idk hard to explain



This post was edited by partank on Feb 2 2013 02:49pm

Copy/paste the formula and manually change the range lol

Can't you reapply a function on a different range?

This post was edited by MeatStick101 on Feb 2 2013 03:23pm

Holy shit why must you people infect this topic with math/numbers or whatever.

theres 365 days so id have to change it 365 times lol
f that

but thats exactly what i want to do. take the average on the next range. no idea how


fuck it. just gonna use the forumla per hour instead of per day so a lot more points on this graph

thanks for the attempt guys

This post was edited by partank on Feb 2 2013 03:37pm

What movie to watch, my choices

City of God(2002)
Perks of being a Wallflower(2012)
Osmosis Jones(2001)
Bronson(2008)
Hugo(2011)

Osmosis Jones ftw

Chris rock as a white blood cell inside of Bill Murray

anyone betting on baltimore for superbowl?

i wanna make a bet, but don't like those idiots in nfl forum