esProc Desktopesproc-desktop.hashnode.dev·13 hours ago#120 — Group by SegmentProblem description & analysis: Here below is a data table: Task: We want to count the number of people in each of the following score segments respectively: below 50, 50–60, 60–70, 70–80, 80–90, and above 90. Solution: Use SPL XLL and enter the fol...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Dec 20, 2024#119 — Group by the ExpressionProblem 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...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Dec 16, 2024#118 — Group by the Combination of Multiple ColumnsProblem description & analysis: Here below is a data table: Task: We want to group the data by Year and Quarter, and count the total sales of each quarter. Solution: Use SPL XLL and enter the following code: =spl("=E(?1).groups(Year,Quarter;sum(Sale...10 likesexcel
Casie Liucasie.hashnode.dev·Dec 13, 2024How to Insert Images in Excel Files or Delete Them Using Python: Detailed GuideIn Excel, adding images can make worksheets more visually appealing and easier to understand. For instance, when organizing a client list, you might want to associate each client with their company logo for quicker identification. On the other hand, ...Python
esProc Desktopesproc-desktop.hashnode.dev·Dec 13, 2024#117 — Simple GroupingProblem description & analysis: Here below is a data table: Task: We want to group the data by Class and calculate the average score of each subject for each class. Solution: Use SPL XLL and enter the following code: =spl("=E(?1).groups(Class;avg(Ma...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Dec 12, 2024#116 — Concatenate Members with the Same RankingProblem description & analysis: Here below is a data table: Task: Rank the students by math score and concatenate the names of students having the same score with comma. Solution: Use SPL XLL and enter the following code: =spl("=E(?1).group(Maths).(...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Dec 11, 2024#115 — Ranking of Row-Based Data — by the ExpressionProblem description & analysis: Here below is a data table: Task: Calculate the ranking of data (in descending order) by the sum of three columns Maths, English and PE. Solution: Use SPL XLL and enter the following code in cell F2: =spl("=E(?1).(Mat...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Dec 10, 2024#114 — Ranking of Row-Based Data — by the Combination of Multiple ColumnsProblem description & analysis: Here below is a data table: Task: Rank the data (in descending order) by the order combination of three columns, Maths, English, and PE. Solution: Use SPL XLL and enter the following code in cell F2: =spl("=?1.rank@z(...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Dec 9, 2024#113 — Ranking of Row-Based DataProblem description & analysis: Here below is a data table: Task: Calculate the ranking of students by TotalScore (in descending order) and fill the results in corresponding cells of column D. Solution: Use SPL XLL and enter the following formula in...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Dec 6, 2024#112 — Ranking of Simple MembersProblem description & analysis: Here below is a data table: Task: Calculate the ranking of members (in descending order) and fill the results in corresponding cells of column B. Solution: Use Excel add-in SPL XLL and enter the following code in cell...10 likesexcel
