close
有個 execl 比對 ... 慢慢看可以 ....那1000 , 10000 行勒 ?
| C090301000161 | C090301000161 |
| C090301000168 | C090301000168 |
| C090302000156 | C090302000156 |
| C090302000160 | C090302000160 |
| C090302000162 | C090302000162 |
| C090302000163 | C090302000163 |
| C090302000169 | C090302000169 |
| C090302000170 | C090302000172 |
| C090303000158 | C090303000158 |
| C090304000224 | C090304000224 |
| C090304000225 | C090304000225 |
| C090306000153 | C090306000153 |
| C090307000150 | C090307000150 |
| C090307000157 | C090307000157 |
| C090307000179 | C090307000179 |
中間插入一行寫
=IF(A1=C1,"","F")
如果是 這樣就馬上找到了 F --- > OK 吧 !
| C090301000161 | C090301000161 | |
| C090301000168 | C090301000168 | |
| C090302000156 | C090302000156 | |
| C090302000160 | C090302000160 | |
| C090302000162 | C090302000162 | |
| C090302000163 | C090302000163 | |
| C090302000169 | C090302000169 | |
| C090302000170 | F | C090302000172 |
| C090303000158 | C090303000158 | |
| C090304000224 | C090304000224 | |
| C090304000225 | C090304000225 | |
| C090306000153 | C090306000153 | |
| C090307000150 | C090307000150 | |
| C090307000157 | C090307000157 | |
| C090307000179 | C090307000179 |
全站熱搜
留言列表
雜七雜八 (1)
