statistical stuff

[CastonjoFfF]

Hi, i'm completely new to any excel programming (or whatever) with the following task to accomplish till Sunday.

I have 3 files-databases (.xls) containing data in ~10000 rows, 10 columns.
The first 2 columns contain date and time values respectively.

What I have to do is applying various (~50) functions such as "return there the average of 4th column only for 1:00AM for each month" or "for each day return there the highest and the lowest value" and make some simple graphs with them.

I know it's probably a simple task to do. I just want to know which is the most quick method i could use, I'm reading excel's help for sometime but has tons of information.
Thank you.

[ChemistB]

Alas, it doesn't sound that simple, particularly without knowing the functions or the setup. You'll want to look at the functions MAX, MIN, MOD, SUMPRODUCT, and INDEX for starters.

ChemistB

[CastonjoFfF]

Thanks for replying,
what I want to know with which tool it's better to work, I mean do I have to write a macro, do I have to play with some functions like the ones you wrote and configure them properly, do I have to write a C++ program? Just to start studying the right thing, in the right way..
Thanks.

[ChemistB]

From the examples you've given, sounds like functions will work fine. I'm sure that examples similar to the ones you mentioned can be found in this forum.

ChemistB

[CastonjoFfF]

Thank you ChemistB..