時(shí)間過得真快，轉(zhuǎn)眼盧子學(xué)習(xí)Excel快20年了，當(dāng)初為了成為高手，吃了無數(shù)苦頭。時(shí)代變遷，曾經(jīng)的經(jīng)典公式，現(xiàn)在幾乎全部被新函數(shù)取代。=-LOOKUP(1,-MID(A2,MIN(FIND(ROW($1:$10)-1,A2&1/17)),ROW($1:$15))) 
新公式：[0-9.]+代表連續(xù)的數(shù)字、小數(shù)點(diǎn)。
=INDEX(A:A,SMALL(IF(MATCH($A$2:$A$72,$A$2:$A$72,0)=ROW($2:$72)-1,ROW($2:$72),4^8),ROW(A1)))&"" 
3.不重復(fù)的項(xiàng)目數(shù)=SUM(1/COUNTIF(A2:A72,A2:A72)) 
4.根據(jù)項(xiàng)目篩選出符合條件的內(nèi)容=IFERROR(INDEX(A:A,SMALL(IF($A$2:$A$72=$J$1,ROW($2:$72)),ROW(A1))),"") 
=FILTER(A2:D72,A2:A72=O1) 
=TRIM(RIGHT(SUBSTITUTE(A2,"-",REPT(" ",50)),50)) 
=TEXTAFTER(A2,"-",-1,,,A2) 
=TRIM(MID(SUBSTITUTE($B2,"、",REPT(" ",50)),COLUMN(A1)*50-49,50)) 
=LEN(B2)-LEN(SUBSTITUTE(B2,"、",""))+1
=COUNTA(TEXTSPLIT(B2,"、"))
|
