請問excel可唔可以做以下"尋找"?

2007-10-26 5:30 pm
類似 WORD既做法:打3456->尋找下一個

545646545415341846545"3456"15435....

咁樣既話可唔可以係EXCEL度做:類似打6 78 54(試過唔得)->尋找下一個,就會穩到A5,A6,A7(注:唔係要穩單一個數,而係要穩一連幾個數或以上)唔該晒!
A1:5
A2:23
A3:14
A4:3
A5:6
A6:78
A7:54
A8:6
A9:8

回答 (1)

2007-10-26 5:37 pm
✔ 最佳答案
In excel, unless you use filter funtion... otherwise, you cannot do what you want...
But the point is... you MUST need to type EVERY number you want...


收錄日期: 2021-04-13 14:11:06
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20071026000051KK00589

檢視 Wayback Machine 備份