華田士多
Published in

華田士多

Excel 小知識:遇到空格時數順序的小技巧

上次講咗點用 data science 喝嘅方法去 Crack Wordle,好似太 hard core 咁,今期番番嚟講啲 Excel 小技巧,今日個實例問題係:

點樣可以自動化左邊黃色嘅數字呢?

其實一拉就可以了,問題係中間有空格…

大家要幫個表做番個 1,2,3,4,5 嘅 sequence,最簡單必定係喺頭兩格輸入 1 同 2,然後 mouse 一拉就可以喇,問題係而家有啲 row 喺空嘅,一拉就爛喇…

--

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
華田 Watin

華田 Watin

Wallace Tin || Sloppy Mercenary || Banks, Languages & Mo-liu Things || fb.me/WatinResearch || patreon.com/watin || watinmedium@gmail.com

More from Medium

Data Literacy in Smart Cities: Why It Is Important

How GREAT Is Data?

Data Science is the Smart Technology Behind the Scenes

Technology background

Everything in, Everything out — The story of our modern data stack