(免費) 有冇人想學Excel formula, 或者想搵人幫手砌excel表

係唔係大家都罷哂工所以冇人入post
不如我同大家玩下遊戲好冇?

想問下向下拉既問題，用ctrl+shift+下制 可以拉到底。咁我第2行用vlookup 有冇快捷鍵可以拉番去第一行既長度。 唔想hold住隻滑鼠一直拉

係你想拉果格既右下角double click就得
前題係你左邊係有野

唔該曬

你要嘅應該係 F8
揀第一點，㩒F8，再飛去第一行 (㩒乜都得,e.g.Ctrl上下左右)，揀第二點，再㩒F8，搞掂。

發覺好多人add 我tg hi 完一句就唔出聲
大家有野就請講啦，唔使怕醜

this is another way using array formula, however, using pivot table is easier and can get rid of the slow array formula

this is also array formula. Btw, you can use pivot table plus slicer like this

no
https://support.office.com/zh-hk/article/textjoin-%E5%87%BD%E6%95%B8-357b449a-ec91-49d0-80c3-0e8fc845691c
this is a new formula in Office 365 / 2019

原來excel終於有一個可以砌得埋array既formula
不過我仲用緊2007

推

好悶

i think concatenate() can do similar things without delimiter.

google sheet provides textjoin() as well, in addition to a lot of useful functions that Excel currently does not support e.g. Query(), sort(), filter(), etc.

F2 and then control + shift + left arrow and then control C
that's is the fastest way I know so far

vlookup is slightly faster than index + match
according to this
https://docs.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-tips-for-optimizing-performance-obstructions

I personally love using vlookup as it is usually syntactically shorter.

alt + e + s
alt + a + e
shift + space
control + space
control + a
I use them all the time

同一個match case 之下只return 一個數就係
多過一個既話將match result save 低就會明顯快過vlookup
return 多過一個數