入黎免費幫你砌excel表 / 教你formula (4)

有冇例子 唔係好識用offset
唔該哂

想用 vba

A1 = 1, B1 = 2 ... J1 = 10
A2 = 11, B2 = 12 ... J2 = 20
... (5 rows in total)

https://www.exceldome.com/solutions/sum-last-n-values-in-a-row/
應該呢個，自己改下d range

唔該哂

如果有一個總表 想篩選出嘅資料copy去一個新嘅worksheet可以點做
e.g. name department post salary
想篩出post係manger嘅資料(出返name department post salary)去一個新worksheet
唔識用vba
感謝

我岩岩上網down左個表黎整, 但係入面D FORMULA VLOOKUP LINK唔到去正確頁面, 大神可唔可以幫我望下點 fix

視乎你個總表係咩樣，應該用pivot table就得

如果我有一堆咁既data
想每逢A/B其中一列同上一行唔同既話就highlight 好似圖入面咁
除左人手慢慢整之外有無方法一次過可以highlight哂?

use can use filter() function (if you are using Excel 365)

第一次見sign呢個function

而家先見到個post
唔知有無教過股票記數
如果我input 呢d資料

做唔做到呢d output

改日子就可以睇到個倉details

其實我就咁用GOOGLE SHEET 用左幾分鐘打出黎