=IF(MAX(LEFT(A1,2),MID(SUBSTITUTE(A1,",","a",1),FIND("a",SUBSTITUTE(A1,",","a",1))+1,2),MID(SUBSTITUTE(A1,",","a",2),FIND("a",SUBSTITUTE(A1,",","a",2))+1,2),MID(SUBSTITUTE(A1,",","a",3),FIND("a",SUBSTITUTE(A1,",","a",3))+1,2),RIGHT(A1,2))-MIN(LEFT(A1,2),MID(SUBSTITUTE(A1,",","a",1),FIND("a",SUBSTITUTE(A1,",","a",1))+1,2),MID(SUBSTITUTE(A1,",","a",2),FIND("a",SUBSTITUTE(A1,",","a",2))+1,2),MID(SUBSTITUTE(A1,",","a",3),FIND("a",SUBSTITUTE(A1,",","a",3))+1,2),RIGHT(A1,2))=4,1,0)
{:soso_e109:}肯定超过45个字符了 |