How does Excel count the number of duplicate names?

1. Open Excel** on the computer.

Select the data for which you want to count names.

2. After selecting the data, click Insert in the toolbar, and then select Insert Pivot Table.

3. After clicking Insert Pivot Table, select a location to place the pivot table.

4. Click OK to pivot and tick all the options on the right.

5. After checking all the options, you can count the number of the same name.

<> assume that D is listed as the names of each person.

Enter or copy and paste the following formula in e1.

len(concat(a$2:b$12))-len(substitute(concat(a$2:b$12),d1,"")))/len(d1)

Pull-down padding. The above formula is only suitable for general situations. If there is Zhang Tingting, and there is Tingting, the following operations are required.

Cut and paste the column B data region below column A. Insert a column to the left of column a. Columns A and C correspond to column B data entry numbers.

<> assume that D is listed as the names of each person.

Enter or copy and paste the following formula in e1.

Pull-down padding.

1. All names are placed in one column.

How Excel can quickly separate data by spaces or the same symbol.

2. Extract the number of duplicates.

How Excel can quickly extract the number of unique data.

It's not advisable to put multiple words in a cell, and it's the same as your table, and you can handle the formula, and you don't understand it, so you might as well divide the columns, separate all the names, and then use the countif function to count, it's very simple.

The countif function is a function in Microsoft Excel to count cells in a specified area that meet the specified criteria, which can be used in versions such as WPS, Excel2003 and Excel2007.

The syntax rules for this function are as follows:

countif(range,criteria) parameter: range the area in which you want to count the number of non-empty cells.

Parameters: criteria Criteria Defined as a number, expression, or textual condition. Thank you.

Non-standard text processing with **.

2. Enter the formula =countif(k8:k14,k8) in **, k8:k14 is the area where the name appears in the selection, and k8 is the cell where the name is located.

3. After entering the formula, press the enter key to find the number of times Xiao Ming appears.

Here's how it works:1. Open an excel** that needs statistical data. As shown in the figure below:

2. In the cell where you want to put the number of statistics, enter =count, and double-click to select the count function.

3. Select the data area to be counted. As shown in the figure below:

4. Press the Enter key, and the number of data in the selected area will be counted.

When using Excel software, select the cell, enter the counta function, you can count the number of names in the cell, a total of 4 steps, the following are the specific steps:

1. Select the cells you need.

2. Enter the required function: Changqi counta(a1:a3).

3. Click the [Green Tick] above.

4. The operation of dismantling Xunyan has been completed.

Excel often needs to count the quantity, so how to use excel to count the number according to the name? Let's take a look! Method.

Open the Excel application.

Please click Enter a description.

Create a new workbook.

Please click Enter a description.

Please click Enter a description.

Inserting the formula doesn't judge the wisdom.

Please click Enter a description.

Insert a function. <>

Please click Enter a description.

Enter the cell with the name.

Please click Enter a description.

Please click Enter a description.

The steps are as follows: enter the workbook that needs to be done to discuss the lead plan, and if there is not much data, you can select any name through the data - automatic filtering, click on the entire D column, and the number can also be counted, but you still need to manually write down the data.

It is also possible to use the sumif function for statistics; The steps are:

1. Make a simple **, set a drop-down menu of names, and the names correspond to the total performance;

2. Enter the function in cell G3, i.e. =sumif;

3. In the function parentheses, select C3-C12 in the region, that is, select all in the name column; If you select F3 as a condition, it is the cell that made the drop-down menu; Select D3-D12 for the summation region, which is all the data of performance.