Golf handicaps?

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=AVERAGE(SMALL(Z$2:INDEX(A$2:Z$2,LARGE(IF(A$2:Z$2< "",COLUMN(A$2:Z$2)),10)),ROW($1:$7)))

Adjust the ranges to suit. I'm assuming that you enter new values at the end
of the range so make the range large enough to allow for additional entries
(future expansion).

Copy down as needed.

If this is for golf hdcp's, once you get to the next level, 10 lowest from
the last 20, you can use this same formula and simply change the 10 to 20
and change ROW($1:$7) to ROW($1:$10).

Oh, I almost forgot.....this assumes that there are enough entries to meet
the requirements (10 entries), to add some robustness you could add this to
the front of the above formula:

=IF(COUNT(A$2:Z$2)<10,"insufficient data",above_formula_here)

Biff

"Bearcats_85" wrote in message
...
I 12 rows of data, each row requires the rolling average.

"Biff" wrote:

Hi!

Is the range going down a column or across a row?

Biff

"Bearcats_85" wrote in message
...
i am trying to average the smallest 7 numbers out of the last ten
entered
(i
can to work if all ten cells have data), how do i handle blank cells so
i
still look at ten cells of data. The data is entered per day and if a
day
is
missed i want to ignore and average with the last ten days data was
entered