前幾次均价 (11398)

 取前幾次均价=IF(B2=B3,"",AVERAGE(OFFSET(D3,,,MIN(COUNTIF(B:B,B3),7))))

取最高前幾次均价{=IF(B2=B3,"",AVERAGE(LARGE(IF(B$3:B$32=B3,D$3:D$32),ROW(INDIRECT("1:"&MIN(COUNTIF(B:B,B3),7))))))