Excel tabulates the number of customers in the list. According to the picture information, it is wps software. There is an advanced mode in the list you filtered. After opening the advanced mode, there is an Export button on the left side of Options, which can export the list results to a new worksheet, as shown in the following figure:

Note: This function requires a member to be used.

If you are not a member, you can use the COUNTIF function to find the input, enter the formula in cell B2, and then fill it down, as shown below:

=COUNTIF(A:A，A2)

The formula and effect diagram are as follows: