Search for a command to run...
Articles tagged with #vba
Problem description & analysis: Here below is a data table: Task: Sort in reverse order by the sum of three columns, Maths, English, and PE. Solution: Use SPL XLL and enter the following formula: =spl("=E(?).sort(Maths+English+PE:-1)",A1:E12) The r...
Problem description & analysis: Here below is a data table of names: Task: Count the number of duplicate names. Solution: Use SPL XLL and enter the formula in cell B2: =spl("=?1.conj().select(~==?2).count()",A$2:A$6,A2) Download esProc Desktop fo...
Problem description & analysis: Here below is an annual and quarterly sales data table: Task: In this table, column A is ordered and has duplicate values. Now we want to clear the data from all rows in the same group except the first row. Solution: ...
Problem description & analysis: Here below is an annual and quarterly sales data table: Task: In this table, the data for the first quarter of 2020 is missing. When the data of this quarter is used to calculate LRR, skip this quarter directly, and u...
Problem description & analysis: There is a sales data table: Task: Count the date when the sales volume of each person reaches 50,000. Solution: Use SPL XLL and the code is as follows: =spl("=E(?1).group(Name).new(Name,~.select@1(Sales[:0].sum()>500...
Problem description & analysis: There is a sales data table: Task: Calculate the cumulative sales of each person. Solution: Use SPL XLL and the code is as follows (to calculate in cell D1): =spl("=E(?1).new(cum(~~+Sales;Name):'Cumulative Sales')",A1...
