Hi!
Goto this page:
http://www.xl-logic.com/pages/formulas.html
Scroll down to item 27. It's a free sample workbook that
will get you started in the right direction. If you
download the sample you'll see that what you want to do is
not so easy!
Biff
-----Original Message-----
I have golf scores in columns b thru r that are entered
weekly.
The league uses handicaping based on the last 5 scores,
eliminating
the lowest score and the highest score, averaging the
remaining 3 scores.
The league uses a rotation system so that a player may
have his last
5 scores spread over 7 or 8 weeks (columns). I need a
formula in column s
that
looks back thru the weeks & finds the last 5 scores for
calculating the
handicap.
The following formula is only applicable if the last 5
are all together in
5 consecutive columns.
(SUM($C5:$G5)-MAX($C5:$G5)-MIN($C5:$G5))/3)-(36))
R Gwin
.