FORMULA

[PICKTR]

I NEED A FORMULA FOR A GOLF LEAGUE.
ONE FORMULA TO CALCULATE
ONLY THE AVG OF THE LAST THREE SCORES ENTERED

EXAMPLE: 38 39 35 = RESULT
X 39 35 43 = RESULT
X X 35 43 41 = RESULT

 

[Alfred Dearnley]

Hi!
Frank Kabel came up with the following (mutatis mutandis).
Assume your scores are going into the cells A1,B1,...,J1 (there are 10 of
them in this case)
Put the following text in cell K1 and array-enter it (ctrl+shift+Enter; not
simply Enter). You'll know if you've done that by the curly braces round the
formula in the formula bar.

=AVERAGE(OFFSET(J1,0,0,1,-(COLUMN(J1)-LARGE(IF(ISNUMBER(A1:J1),COLUMN(A1:J1)
),3)+1)))

Alf



| I NEED A FORMULA FOR A GOLF LEAGUE.
| ONE FORMULA TO CALCULATE
| ONLY THE AVG OF THE LAST THREE SCORES ENTERED
|
| EXAMPLE: 38 39 35 = RESULT
| X 39 35 43 = RESULT
| X X 35 43 41 = RESULT

 

[RagDyer]

GEEeee!
It seems we've got two threads with the same subject title!

This'll be real comprehensible in a Google search ... won't it?

Anyway, to PICKTR,

With data entered or *to be* entered in A1:J1,
type this array formula into K1:

=AVERAGE(J1:INDEX(A1:J1,LARGE(COLUMN(A1:J1)*(A1:J1<>""),3)))

As an array formula, it must be entered with <Ctrl> <Shift> <Enter>.
If done correctly, the formula will *automatically* be enclosed in curly
brackets.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I NEED A FORMULA FOR A GOLF LEAGUE.
ONE FORMULA TO CALCULATE
ONLY THE AVG OF THE LAST THREE SCORES ENTERED

EXAMPLE: 38 39 35 = RESULT
X 39 35 43 = RESULT
X X 35 43 41 = RESULT