John Bundy wrote:
Depending on the layout, the Data-Subtotal method would be the easiest. If
each sample has say a name then at each change in that name average the data
column. Other than that an array can loop through every 60 and get an average
but I need to know how it is layed out e.g each sample is in one row and
column or seperate columns/sheets.


Thanks for the response. The data is a three digit number, one per row,
in one column and on the same sheet.

Cheers,
Kevin