給定一段話(huà),如何找關(guān)鍵詞?【專(zhuān)家解說(shuō)】：作定語(yǔ)修飾性的詞

EXECL中如何用分式找出關(guān)鍵字，并帶上關(guān)鍵字的數(shù)量？【專(zhuān)家解說(shuō)】：B1=ABS(LOOKUP(1,-RIGHT(LEFT(A1,FIND("Q",A1)-1),ROW($1:$1