EXCEL的A中有1000个五位数，每个五位数之间用空格隔开，B中有600个五位数，想要在C中找出剩余400个五位数

2007及以上版本支持：=TEXT(SUM(SMALL(IFERROR(--IF(COUNTIF(B1,"*"&MID(A1&" ",ROW(INDIRECT("1:"&(LEN(A1&" "))/5))*5-4,4)&"*"),"",MID(A1&" ",ROW(INDIRECT("1:"&(LEN(A1&" "))/5))*5-4,4)),""),ROW(INDIRECT("1:"&COUNT(--IF(COUNTIF(B1,"*"&MID(A1&" ",ROW(INDIRECT("1:"&(LEN(A1&" "))/5))*5-4,4)&"*"),"",MID(A1&" ",ROW(INDIRECT("1:"&(LEN(A1&" "))/5))*5-4,4))))))*10000^ROW(INDIRECT("1:"&COUNT(--IF(COUNTIF(B1,"*"&MID(A1&" ",ROW(INDIRECT("1:"&(LEN(A1&" "))/5))*5-4,4)&"*"),"",MID(A1&" ",ROW(INDIRECT("1:"&(LEN(A1&" "))/5))*5-4,4)))))/10000),REPT(" 0000",COUNT(--IF(COUNTIF(B1,"*"&MID(A1&" ",ROW(INDIRECT("1:"&(LEN(A1&" "))/5))*5-4,4)&"*"),"",MID(A1&" ",ROW(INDIRECT("1:"&(LEN(A1&" "))/5))*5-4,4)))))

ctrl+shift+回车