find consecuetive means

[Thomas Wright]

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

 

[Thomas Wright]

to meet a goal of 15


or in other words,

a set of three that average to a goal and then finds the next such set.

Tom

 

[Bernard Liengme]

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

 

[Jason Morin]

I'd keep it simple. With your values starting in A1, put
this in B1 and fill down:

=IF(AVERAGE(A1:A3)=15,"Hit","")

Any cell with "Hit" means the adjacent cell in A and the
2 cells below that have an avg. of 15.

HTH
Jason
Atlanta, GA

 

[Biff]

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

 

[Bob Tarburton]

To avoid scrolling down in a long list
B1> =IF(SUM(A1:A3)=45,1,"")
B2> =IF(SUM(A2:A4)=45,1+MAX(B$1:B1),"")
Copy B2 down
C1> =match(row(1:1),B:B,0)
Copy C1 down
COlumn C returns the first rown of every 3 number sequence

 

[Sandy Mann]

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

 

[Thomas Wright]

Thanks everyone. It was more straightforward than I thought.

Tom

 

[Bernard Liengme]

Just to show that the method works!