cell A1=顧客號碼(e.g. abc) B1:B10 = sales order no. (001 to 010)
cell A11= 顧客號碼(e.g. def) B11:B20 =sales order no. (026 to 035) etc
請問用甚麼方法可以填滿 A2:A10 顧客號碼？用新column 都可以，我目的是要在vlook sales order 時可以look 到 顧客號碼。
excel 問題 - 特急
2007-06-23 8:34 pm
回答 (1)
2007-06-24 8:15 am
✔ 最佳答案
drag and copy for all your data 囉..(or give me 10 bugs for to do that..)
2007-06-24 00:30:30 補充：
I use additional column,, say C,,C1=A1C2=IF(A11＜＞””,A11,C10) then drag and copy the formula..copy all the formula,, right click,, paste special,, paste values only..
參考: give me 10 bugs..
收錄日期: 2021-04-12 21:44:19
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070623000051KK01504