請問表格內的是 6個位的數字, 可以只篩選尋找開頭的三個數字嗎?
例如: 以下的數字, 我可以只篩選出以 621 為首的所有資料嗎? 謝謝幫忙~
621001
724003
621008
825006
934012
621338
724024
621002
Excel 可以只篩選頭三個數字嗎?
2008-04-01 12:51 pm
回答 (3)
2008-04-01 2:23 pm
✔ 最佳答案
你可以用[查詢], 鍵入 SQL command 即可.舉例, 假設 Table 名係 MyTable, 欄位係 MyField, 則 SQL 係:
SELECT * FROM MyTable WHERE LEFT(MyField,3)='621'
Hope this help.
2008-04-01 09:17:39 補充：
Yes. philipwong326 是正確的.
我睇錯左係 Access. ^_^"
2008-04-01 5:57 pm
用 Data Pull-down Menu 的 AutoFilter function 在該欄上
選 Custom，然後填上
is greater than or equal to 621000
AND
is less than or equal to 621999
選 Custom，然後填上
is greater than or equal to 621000
AND
is less than or equal to 621999
2008-04-01 3:26 pm
Assume those data in column A1 through A8
then you can put this formula in cell B1
=left(A1,3)
then you will see the following in Column B
621
724
621
825
934
621
724
621
Then you can use Autofilter (ALT+D+F+F) to find 621 in column B.
done.
then you can put this formula in cell B1
=left(A1,3)
then you will see the following in Column B
621
724
621
825
934
621
724
621
Then you can use Autofilter (ALT+D+F+F) to find 621 in column B.
done.
參考: myself
收錄日期: 2021-04-16 23:20:10
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20080401000051KK00314