Please follow the steps as below 1. Select cell G3 2. Right click mouse 3. Select format cell 4. Select number tab 5. Select General then click OK 6. Cell G3 should display year YYYY number
@@KKLeungThank you Leung Sir, thanks for your time on my small mistake. Right now I am learning Vlookup, while I was doing some examples, I have found out that if you have a space in front of your text input in a cell , you can't do an exact match. I have learned to use trim function before starting the vlookup. Thank you again.
Sorry,手快快將文佔佔上在此處以下!我亦不能即時或及時將它刪除,真的不好意思,這篇文章並非給予你閣下的,唯有請你要理會或當作我攪錯吧!
👌
多謝分享
多謝收看
KK老師, 你教得好好,我想知道你有冇在綱上教如何用Word tools? 因為只見你教Excel. 多謝!
Hi Florence
多謝你嘅好評,協助轉介給有需要嘅朋友,就是對本平台嘅義工們最大支持。
Word 我較少用,所以未能在綱上交流經驗。
謝謝
LEUNG SIR, in this example, when I input this at G3, =year(B5), it gives me this result
04-jul-05. Even though the B5 data is input as , 1-feb-12.
多謝你嘅提問,會安排時間處理,遲啲回覆你。
Please follow the steps as below
1. Select cell G3
2. Right click mouse
3. Select format cell
4. Select number tab
5. Select General then click OK
6. Cell G3 should display year YYYY number
@@KKLeungThank you Leung Sir, thanks for your time on my small mistake. Right now I am learning Vlookup, while I was doing some examples, I have found out that if you have a space in front of your text input in a cell , you can't do an exact match. I have learned to use trim function before starting the vlookup. Thank you again.
Excellent
Thanks for your watching
再加入重量, 比一個range 的收費。 eg 1-100 kgs 收100元, 101-500kgs 收 150 元
多謝收看
計年齡方法有點不準確,生日前已經加咗加大咗歲,是嗎?
收到你嘅提問,覆核後回覆你,謝謝。
Hi Amy,
好感謝你指出問題所在..
方法1:
因為年齡整數是用365去計算. 所以會有幾日嘅誤差.
方法2:
原意避免方法1 嘅誤差, 但未有考慮到 DOB(DD/MM)同Today()(DD/MM)差異, 所以當未到達DOB, 會有overstated 情況出現.
經修改後 Formula如下:
DATEDIF(B5,TODAY(),"y")
B5=DOB (date of birth)
再次多謝你有關問題嘅反饋, 如再有問題歡迎留言交流.
K.K.
想請教師兄如何 做 ( 之前打錯 從打多次) $A(n) = $A(n-2) + n
多謝你嘅提問,未能太明白你嘅意思,可以再具體講述一次。
@@KKLeung 多謝師兄回覆 之前打錯 從打多次 $A(n) = $A(n-2) + n, n is row number
Hi Brother,
我是大概估你嘅用途是這樣, 請嘗試用下面formula. 如有問題歡迎留言再交流.
=INDIRECT("$A"&TEXT(ROW()-2+ROW(),0))
你好KK,車牌,SD-6008呢個format點樣set?thsnks
Hi Carman,
是否所有車牌前都是有兩個英文字?如是否,好可能要power query 方法。