標題:
如何抓取關鍵字
[打印本頁]
作者:
sunnyso
時間:
2014-3-13 21:50
標題:
如何抓取關鍵字
關鍵字爲"瓶", "盆", "桶", "盒".
A欄中必有其一,但是沒固定規律, 請問如何抓取?
感謝大大
[attach]17758[/attach][attach]17759[/attach]
作者:
Bodhidharma
時間:
2014-3-21 16:57
回復
1#
sunnyso
B2公式(CTRL+SHIFT+ENTER三鍵鍵入)
=INDEX({"瓶","盆","桶","盒"},,SUM(IFERROR(FIND({"瓶","盆","桶","盒"},A2)^0*COLUMN(A:D),)))
複製代碼
作者:
samwang
時間:
2014-3-25 12:08
B2公式=LOOKUP(1,0/FIND({0,"瓶","盆","桶","盒"},A2&0),{"","瓶","盆","桶","盒"})
作者:
Hsieh
時間:
2014-3-26 14:22
回復
1#
sunnyso
=LOOKUP(2,1/ISNUMBER(FIND({"瓶","桶","盒","盆"},A2)),{"瓶","桶","盒","盆"})
作者:
sunnyso
時間:
2014-3-26 19:30
感謝大大們....
作者:
准提部林
時間:
2014-3-26 23:07
參考參考:
=LOOKUP(,-FIND({"","瓶","盆","桶","盒"},A2),{"","瓶","盆","桶","盒"})
=MID("瓶盆桶盒",MATCH(,0/FIND({"瓶","盆","桶","盒",""},A2),),1)
作者:
ML089
時間:
2014-3-27 09:03
回復
1#
sunnyso
關鍵字爲"瓶", "盆", "桶", "盒".
A欄中必有其一,但是沒固定規律, 請問如何抓取?
既然必有其一，公式可以簡單一些
=MID(A2,-LOOKUP(,-FIND({"瓶","盆","桶","盒"},A2)),1)
作者:
sunnyso
時間:
2014-3-27 09:33
回復
7#
ML089
厲害
作者:
mannings
時間:
2014-4-4 12:08
參考參考:
=LOOKUP(,-FIND({"","瓶","盆","桶","盒"},A2),{"","瓶","盆","桶","盒"})
=MID("瓶盆桶盒",MATCH(,0/FIND({"瓶","盆","桶","盒",""},A2),),1)
歡迎光臨 麻辣家族討論版版 (http://forum.twbts.com/)
