i am and i dont even understand how to use it in this situation.

what im trying to do is get the average temperature for each day.
im given the temperature at each hour, for 365 days

Yeah.
And it's really not that hard to use either.

e:

Vlookup doesn't apply here I don't think.

This post was edited by chreeeis on Feb 2 2013 02:21pm

yea thats what i thought lol

1) Lookup_value – The value you want to look up

first variable is that and im not looking up anything hah

Oh I never fully understood the problem

I thought you were trying to make new data tables

Sorry haha

It's really simple.
I just forget how to use excel at this point D:

it sounds incredibly simple, but i cant seem to find the forumla
you guys know anyone decent @ excel?

ty though funbuns

dx and tom are probably good

I've had to take a million excel classes but I don't really get what isn't working for you

plus they were pretty useless classes

They drag down thing keeps the 1-24 gap, but it won't go to 25-49.
It'll just go to 2-25 instead.

yea exactly. i want the next range of cells to be under cell 24, not 2-25