Array puzzle果度更新咗少少野
https://www.excel4freehk.com/e4fhk/challenge/array-puzzle
因為有時有人問我拎提示或者答案
而家我放哂每題會用到啲咩FUNCTION出黎
諗唔掂果時可以睇下有冇頭緒
但要留意兩樣野:
1. 呢張list既就係我用咗嘅「所有」FUNCTION,即係理論上你淨係用我LIST出黎既FUNCTION就可以做到答案,但當然有啲FUNCTION會重覆用好多次,同埋operator係冇寫出黎(即係+ - * / > = < 果啲)
2. 我寫Formula既風格同你可能好唔同,盲目咁跟我用嘅FUNCTION有機會令你更加諗唔到點做
Q1.1 - IFERROR LARGE SUBSTITUTE
Q1.2 - IFERROR SMALL SUBSTITUTE
Q1.3 - IFERROR SMALL SUBSTITUTE TEXT
Q2 - IF IFERROR MID PRODUCT REPT ROW SUBSTITUTE SUM TEXT
Q3 - RIGHT MID ROUNDDOWN SUM
Q4 - REPT RIGHT ROUND ROUNDDOWN ROW SMALL SUBSTITUTE SUM TEXT VLOOKUP
Q5.1 - LEN SUBSTITUTE SUM
Q5.2 - LEN MID SUBSTITUTE SUM TEXT
Q5.3 - LARGE LEN SUBSTITUTE SUM
Q5.4 - IF IFERROR LARGE LEN MATCH MOD RIGHT ROUND ROW SMALL SUBSTITUTE
題外話
我統計咗呢10個分題入面function既使用率
原來我用得最多嘅竟然係SUBSTITUTE (壓倒性90%, 即係10題入面有9題要用SUBSTITUTE)
本來以為用得最多係small large或者sum果啲