1. Open an Excel table containing data. In this experience, take a table with 40,000 data points as an example, and select 1 data point for data slimming every1data point.

2. Numbering data points: first, manually enter the starting value of 0, then select the cells to be filled, and click Fill-Series-Arithmetic Series-Forecast Trend-OK to finish numbering.

3. Using the remainder formula MOD (dividend, divisor), we get the cyclic sequence 0, 1, ..., 9: Enter =mod(D2, 10) to get the first remainder 0; Select the cells to be filled, press Ctrl+D to fill the whole column of cells, and get the cyclic sequence with the remainder of 0, 1, ...

4. Use the filter tool to select 1 data point every 10 data point: select the whole column (0~9 circular columns), click Filter, and check 0 in the filter criteria to get the data of every 10 data point.

Precautions:

You can modify the divisor according to your own needs, such as 1 for every 20 data points, and the function is mod (dividend, 20).