Just to show that the method works!

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Sandy Mann" wrote in message
...
Bernard,

Can you explain your logic in putting 10 in A9, especially as the OP wants
to find *Three* cells that average 15? Your method finds a match in cell
B7
even although the only *real* numbers left in the OP's data don't average
15.

Puzzled,

Sandy

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Bernard Liengme" wrote in message
...
With your numbers in A1:A8 (put 10 in A9) use =IF(SUM(A1:A3)=45,"*","")
in
B1
Copy down the column.
I used SUM because AVERAGE gets confused at the end of the series
best wishes

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Thomas Wright" wrote in 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