Matt,

A _small_ data table showing what you mean, and the result you would expect from the example, would
be of great help in presenting a solution.

I do not want to do the average of all
Mode 1's, rather the individual averages of all cycles.

HTH,
Bernie
MS Excel MVP


"Matt S" wrote in message
...
Hi all (again),

I have successfully made an array that labels my data into 4 modes. The 4
modes repeat continuously for fifty hours, so my labelarray labeled what mode
I'm in per second.

Now I have the arduous task of doing calculations on the array while it is
in a certain mode cycle. For example, I'd like to take the average of my
TemperatureArray while my LabelArray is in Mode 1 for this cycle and record
that cycle average in a new array. I do not want to do the average of all
Mode 1's, rather the individual averages of all cycles.

I've been sitting here for an hour trying to think of a conceptual way to do
this, but am completely stumped.

Any suggestions??
THANKS!
Matt