Simone
=IF(MAX(OFFSET($DH$58,,MATCH(OFFSET($B134,,$ES$1),$DI$22:$DM22,),76,))=MAX($EP135:EP135),"",SMALL(OFFSET($DH$58,,MATCH(OFFSET($B134,,$ES$1),$DI$22:$DM22,),76,),COUNTIF(OFFSET($DH$58,,MATCH(OFFSET($B134,,$ES$1),$DI$22:$DM22,),76,),"氏旦<="&EP135)+1))看指核毕了半唯芹天才明白一些,你先试试
