View Single Post
  #8   Report Post  
Biff
 
Posts: n/a
Default

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


.