find consecuetive means
 

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

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

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

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

-----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


.

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


.

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

-----Original 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



.

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

Thanks everyone. It was more straightforward than I thought.

Tom


"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

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