发布网友
共1个回答
热心网友
E2:
=LOOKUP(1,0/($B$2:B1000<>""),ROW($2:1000))-IFERROR(LOOKUP(1,0/(FIND(LEFT(D2),$B$2:B1000)*FIND(RIGHT(D2),$B$2:B1000)),ROW($2:1000)),1)