Last 10 occurance or available occurance average

Hello Friends

I want to find the average for last 10 occurance in light yellow cells. If the occurance is less than 10 then the available values average to be plotted.

Please find the attached excel 97 version file <Last 10 occurance or available occurance average.xls>

thanks

thilag

Dear,

I donīt now if you have just excel 97, for another version you can try "=AGGREGATE(1;6;C1:L1)"

Originally Posted by Heverton

Dear,

I donīt now if you have just excel 97, for another version you can try "=AGGREGATE(1;6;C1:L1)"

hello Heverton the AGGREAGATE function works only from version 2010 and 2013
Bye

Hello Heverton & GerryZucca

thanks for your answers, it helped me lot.

Gerry the formula is <=AGGREGATE(1,6,C1:L1)> , instead ;

thanks again

thilag