Hi!
Maybe something like this:
Assume your values are in the range A1:A8.
In B3 enter this formula and copy down:
=AVERAGE(OFFSET(A3,,,-3))=15
Biff
-----Original Message-----
find a set of cells: three consecutive cells that when
averaged meet a goal
and then finds the next set in a column.
Goal = 15 averged for three consecuetive cells.
10
15
20
15
12
13
15
20
This is my problem. Can anyone come up with suggestions
that helps me solve
this problem?
Thank you,
Tom Wright
.
|