Excel 真係好撚難 可以點學？ 返工返到灰

無知一問, 點樣可以係database入面summary一個檔案既latest version 係跟英文字母而唔係數字

自問formula已經熟到玩無可玩既巴打,機會黎啦

試下用formula玩下fb hacker cup
玩完實學到野
以下呢幾條係小弟玩完,合理地可以用formula做到既題目

2011 Double Squares ← 簡單數學題
2012 Alphabet soup ← 超簡單String Operation,入門必玩
2013 Beautiful strings ← 字母湯加強版
2015 Cooking the books ← String Operation 地獄

(2014 Square Detector我抽起左review緊)

題目同example見link↓


規則好簡單, 每個case一條formula出答案, NO VBA, NO NAMES

想再挑戰多D既試下將條式縮到有咁短得咁短
以下係小弟暫時成績(直接用LEN()計character數目):

2011 Double Squares : 83 char (冇加Case # heading)
2012 Alphabet soup : 82 char (冇加Case # heading)
2013 Beautiful strings : 106 char (冇加Case # heading)
2015 Cooking the books : 341 char

一時唔識玩都可以交流下
可以教下你起機步

計埋{} = 76 char
P.S. 睇左比古答案先識做

自問formula已經熟到玩無可玩既巴打,機會黎啦

試下用formula玩下fb hacker cup
玩完實學到野
以下呢幾條係小弟玩完,合理地可以用formula做到既題目

2 data-thumbnail-src="https://i.lih.kg/thumbnail?u=https%3A%2F%2Fimg.eservice-hk.net%2Fupload%2F2017%2F10%2F22%2F181912_fd4c8e59b8a7add298869bd9fef2417c.JPG&h=2ce92821&s={SIZE}"11 Double Squares ← 簡單數學題
2 data-thumbnail-src="https://i.lih.kg/thumbnail?u=https%3A%2F%2Fimg.eservice-hk.net%2Fupload%2F2017%2F10%2F22%2F181912_fd4c8e59b8a7add298869bd9fef2417c.JPG&h=2ce92821&s={SIZE}"12 Alphabet soup ← 超簡單String Operation,入門必玩
2 data-thumbnail-src="https://i.lih.kg/thumbnail?u=https%3A%2F%2Fimg.eservice-hk.net%2Fupload%2F2017%2F10%2F22%2F181912_fd4c8e59b8a7add298869bd9fef2417c.JPG&h=2ce92821&s={SIZE}"13 Beautiful strings ← 字母湯加強版
2 data-thumbnail-src="https://i.lih.kg/thumbnail?u=https%3A%2F%2Fimg.eservice-hk.net%2Fupload%2F2017%2F10%2F22%2F181912_fd4c8e59b8a7add298869bd9fef2417c.JPG&h=2ce92821&s={SIZE}"15 Cooking the books ← String Operation 地獄

(2 data-thumbnail-src="https://i.lih.kg/thumbnail?u=https%3A%2F%2Fimg.eservice-hk.net%2Fupload%2F2017%2F10%2F22%2F181912_fd4c8e59b8a7add298869bd9fef2417c.JPG&h=2ce92821&s={SIZE}"14 Square Detector我抽起左review緊)

題目同example見link↓


規則好簡單, 每個case一條formula出答案, NO VBA, NO NAMES

想再挑戰多D既試下將條式縮到有咁短得咁短
以下係小弟暫時成績(直接用LEN()計character數目):

2 data-thumbnail-src="https://i.lih.kg/thumbnail?u=https%3A%2F%2Fimg.eservice-hk.net%2Fupload%2F2017%2F10%2F22%2F181912_fd4c8e59b8a7add298869bd9fef2417c.JPG&h=2ce92821&s={SIZE}"11 Double Squares : 83 char (冇加Case # heading)
2 data-thumbnail-src="https://i.lih.kg/thumbnail?u=https%3A%2F%2Fimg.eservice-hk.net%2Fupload%2F2017%2F10%2F22%2F181912_fd4c8e59b8a7add298869bd9fef2417c.JPG&h=2ce92821&s={SIZE}"12 Alphabet soup : 82 char (冇加Case # heading)
2 data-thumbnail-src="https://i.lih.kg/thumbnail?u=https%3A%2F%2Fimg.eservice-hk.net%2Fupload%2F2017%2F10%2F22%2F181912_fd4c8e59b8a7add298869bd9fef2417c.JPG&h=2ce92821&s={SIZE}"13 Beautiful strings : 1 data-thumbnail-src="https://i.lih.kg/thumbnail?u=https%3A%2F%2Fimg.eservice-hk.net%2Fupload%2F2017%2F10%2F22%2F181912_fd4c8e59b8a7add298869bd9fef2417c.JPG&h=2ce92821&s={SIZE}"6 char (冇加Case # heading)
2 data-thumbnail-src="https://i.lih.kg/thumbnail?u=https%3A%2F%2Fimg.eservice-hk.net%2Fupload%2F2017%2F10%2F22%2F181912_fd4c8e59b8a7add298869bd9fef2417c.JPG&h=2ce92821&s={SIZE}"15 Cooking the books : 341 char

一時唔識玩都可以交流下
可以教下你起機步

計埋{} = 76 char
P.S. 睇左比古答案先識做

good
番屋企俾你睇下我點解83

2 data-thumbnail-src="https://i.lih.kg/thumbnail?u=https%3A%2F%2Fimg.eservice-hk.net%2Fupload%2F2017%2F10%2F22%2F181912_fd4c8e59b8a7add298869bd9fef2417c.JPG&h=2ce92821&s={SIZE}"13 = 9 data-thumbnail-src="https://i.lih.kg/thumbnail?u=https%3A%2F%2Fimg.eservice-hk.net%2Fupload%2F2017%2F10%2F22%2F181912_fd4c8e59b8a7add298869bd9fef2417c.JPG&h=2ce92821&s={SIZE}" char (計{}, 唔計有$)

趁有D人係度玩下不如我擺埋自己寫果D題目出黎?

好, 2015個條似煩多過難, 唔打算做

最慘係人地整左個template，入面啲formula完全睇唔明，有野改都唔識改

是 尤其是上一手同事揼出黎俾你上司 但係佢已經走左而你上司仲用緊 之後叫你睇明佢/用呢份做

有得跟有幾難
你老闆話日日有一億條數好機械咁計
你唔識寫VBA / marco果陣要自己計仲慘

有得跟，上手有VBA/macro已經好好

返工腦細要我改上手啲VBA

痴線一打開有五六十個functions/ sub
要睇一次先知點改