Problem description & analysis: Here below is a data table: Task: We want to group and aggregate by the first two digits of ID, and calculate the total sales of each group. Solution: Use SPL XLL and enter the following code: =spl("=E(?1).groups(left...
esproc-desktop.hashnode.dev1 min read
esProc
👉 Stay tuned for more Excel pro tips with SPL XLL:
Discord:discord.gg/cFTcUNs7 Reddit: reddit.com/r/esProc_Desktop