序號整數相同 最大值打勾 (10859)

G2{=IF(MAX((LEFT(A$2:A$16,FIND(".",A$2:A$16)-1)=LEFT(A2,FIND(".",A2)-1))*(LEFT(A2,FIND(".",A2)-1)/1%+F$2:F$16))=LEFT(A2,FIND(".",A2)-1)/1%+F2,"V","")

序號整數 最多99{=IF(LEFTB(A2,2)/1%+MAXA((LEFTB(A$2:A$16,2)=LEFTB(A2,2))*F$2:F$16)=LEFTB(A2,2)/1%+F2,"V","")

另解{=IF(INT(A2)/1%%+MAX((INT(A$2:A$16)=INT(A2))*F$2:F$16)=INT(A2)/1%%+F2,"V","")