Excel Tips : 9 個 Excel Tricks (小秘訣) 幫你提升工作效率 | 質量 👍

[@Teen1-vi1rj]

真的要讚無限次，期待再有類似係列

[@KKLeung]

@@Teen1-vi1rj 多謝收看

[@spleung7604]

Thanks

[@KKLeung]

@@spleung7604 多謝收看

[@ckfong5196]

近日看到閣下视频，现有一個問题出现，想向閣下請教 ? 由A1-F1 直落有不同数字，當我想查 B1行数字由大至小時（Sort&Filter 按钮），就出现 A1行以下的次序混亂，而問题混亂情形是A1行滑下A2行才全筛选，如何有解决辦法？我将多個KZbinr视频多種方法嘗試，未能解决！謝謝🙏

[@KKLeung]

多謝收看 1 當你做B1排序操作, 問題你是否期望A1 column資料 次序應否改變? 2 如果你不想A1 column有任何變動, 就要多插一個column分開原有A1與B1資料

[@candyng8169]

多謝！

[@KKLeung]

Hi Candy, 非常感謝你的支持🙏

[@williamlikc88]

Useful

[@KKLeung]

@@williamlikc88 多謝收看

[@fsleung528]

Hello, may I ask what is the logic of "check duplicate"? will it only keep the first row of the order number? what if we want to find the dates of a certain status for all the order number? thanks!

[@KKLeung]

Thanks for watching Q1/Q2 Logic of Check Duplicate: Select the column you want to check for duplicates - in this case, the order number column. Sort the data first by order number in descending order, then by date in descending order (newest to oldest). When you execute the "Remove Duplicates" action, it will only keep the first row for each unique order number, and remove all the duplicate order numbers. Since it keeps the row with the newest date, you can find the latest status for each order number. Q3 Querying for Specific Dates and Statuses: I covered how to use the Advanced Filter feature to do this in another video, which you can check out here: kzbin.info/www/bejne/aWOtYX-ugdt4fZYsi=XaYYv9CdKhHB7Qco Let me know if this helps explain the functionality you were asking about. I'm happy to clarify or provide any additional details.

[@KKLeung]

Thanks for watching Q1/Q2 Logic of Check Duplicate: Select the column you want to check for duplicates - in this case, the order number column. Sort the data first by order number in descending order, then by date in descending order (newest to oldest). When you execute the "Remove Duplicates" action, it will only keep the first row for each unique order number, and remove all the duplicate order numbers. Since it keeps the row with the newest date, you can find the latest status for each order number. Q3 Querying for Specific Dates and Statuses: I covered how to use the Advanced Filter feature to do this in another video, which you can check out here: kzbin.info/www/bejne/aWOtYX-ugdt4fZYsi=XaYYv9CdKhHB7Qco Let me know if this helps explain the functionality you were asking about. I'm happy to clarify or provide any additional details.

[@kathyleung6741]

如果我想喺Excel prefix加上兩個00做order number開頭嘅數字，我應該點做法呢？😊

[@KKLeung]

Hi Kathy, 多謝收看, 請按下列步驟 1 選用custom format 2 輸入 ”00”0 3 Format就會顯示前面加多兩個零 4 要留意儲存格內容是沒有改變的 如有問題再留言交流 KK

[@carman8881]

你好KK, 怎樣將用formate D字變回真實文字？

[@KKLeung]

Hi Carman, 如果要將原本內容改變加上prefix “00”, 就必須要用 Formula Cell A1=123456 Cell B1=”00”&A1 Then Cell B1=00123456 Thx K.K.

[@casawabicat9475]

請問你用的Excel是什麼版本？

[@KKLeung]

@@casawabicat9475 我是用Excel 365 版

[@paulyeung5628]

🥰❤❤🙏🙏🙏

[@KKLeung]

Hi Paul, thanks for watching 😁