- 帖子
- 560
- 主題
- 159
- 精華
- 0
- 積分
- 723
- 點名
- 0
- 作業系統
- WINDOWS
- 軟體版本
- xp
- 閱讀權限
- 50
- 性別
- 男
- 來自
- 桃園
- 註冊時間
- 2014-9-10
- 最後登錄
- 2023-10-31
  
|
DEAR SIR
1.E5,I5,M5,Q5,I7,L7,K10 - 用圖一
2.D10,F10,O10,E12,P12,J15,L15,K18 - 同方式自行修改儲存格
圖一
=IF(ISERROR(SEARCH(0,E5&I5&M5&Q5&I7&L7&K10)),0,"")&IF(ISERROR(SEARCH(1,E5&I5&M5&Q5&I7&L7&K10)),1,"")&IF(ISERROR(SEARCH(2,E5&I5&M5&Q5&I7&L7&K10)),2,"")&IF(ISERROR(SEARCH(3,E5&I5&M5&Q5&I7&L7&K10)),3,"")&IF(ISERROR(SEARCH(4,E5&I5&M5&Q5&I7&L7&K10)),4,"")&IF(ISERROR(SEARCH(5,E5&I5&M5&Q5&I7&L7&K10)),5,"")&IF(ISERROR(SEARCH(6,E5&I5&M5&Q5&I7&L7&K10)),6,"")&IF(ISERROR(SEARCH(7,E5&I5&M5&Q5&I7&L7&K10)),7,"")&IF(ISERROR(SEARCH(8,E5&I5&M5&Q5&I7&L7&K10)),8,"")&IF(ISERROR(SEARCH(9,E5&I5&M5&Q5&I7&L7&K10)),9,"") |
|
發表於 2016-6-2 15:58
| 
