Search for a command to run...
Articles tagged with #tutorial
Problem description & analysis: Here below is a data table: Task: We want to insert one blank row when the values in two adjacent rows change, the result is as follows: Solution: Use SPL XLL and enter the following code: =spl("=?1.conj().group@o(~)...
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...
Problem description & analysis: Here below is a data table: Task: We want to sort the data in ascending and descending orders by TotalScore. Solution: Use SPL XLL and enter the following formulas respectively: Sort in ascending order by TotalScore:...
Problem description & analysis: There is a data table: Task: Find out the data that are not duplicate and the first duplicate data in the Name column: Solution: Use SPL XLL and enter the following formula: =spl("=E(?1).group@u(Name).(~(1))",A1:D7) ...
Problem description: The following table lists the top 10 products by sales in January and February: Solutions: Use SPL XLL and deal with the following tasks respectively. A. Find out the products that make the top 10 in both January and February: =...
Problem description & analysis: Here below is an annual and quarterly sales data table: Task: Calculate the proportion of each quarterly sales to the total sales of the year (to calculate in cell D1). Solution: Use SPL XLL and the code is as follows...
