Newbies here, can excel manage to automate this process?

[changeable]

your criteria doesnt make any sense...

is each line one a criteria?

like this
-Monday 7:00:00 3.137263<=Y<=3.138149- means day = monday AND time =
AM AND (3.137263<=Y<=3.138149)

and a . (dot) means any day or time

-21:00:00 101.692597<=X<=101.693463- means any day

Please clarify.

Oops, i am sorry for my bad presentation of my question.

Well basically it should look like this:

For all data that meet "Day = Monday" AND "Time BETWEEN 7:00:00 an
7:05:00" AND "3.137263<=Y<=3.138149", i need to get the average an
standard deviation of the SPEED.

NEXT, by holding the "Day" AND "Time" criteria, but varying th
"segment" criteria. I need the average and standard deviation of SPEE
for all data points that fall within each "segment" criteria.

This process continue until the last "segment" criteria is scanned
THEN, i will have to Remain the "Day" but modify the "Time" criteria t
"Time BETWEEN 7:05:01 and 7:10:00" AND starting to varying the "segment
criteria from the first segment to last segment and so on.

Which means, the combination should be : DAY *TIME BETWEEN*SEGMENT
if i have 7 days, 169 time intervals and 127 segments. I'll nee
7*169*127 sets of data.

I hope this clarify my question a bit more.
Thanks for replying me

+-------------------------------------------------------------------
|Filename: untitled.gif
|Download: http://www.excelforum.com/attachment.php?postid=2734
+-------------------------------------------------------------------