Filter by repetitions
Jul 21, 2021
Example
There is an Excel file Book1.xlsx, and part of the data is as follows:
Find the months with less than 4 repetitions, and the results are as follows:
Write SPL script:
A1 Read excel file
A2 Group the data, filter out the results with less than 4 in the group, and take one value for each group
A3 Export results to result.xlsx