There are a few ways to get a count of unique names in Excel. One way is to use the COUNTIF function. This function counts the number of cells that meet a certain criteria. For example, you could use the COUNTIF function to count the number of cells that contain the word "John".

Another way to get a count of unique names in Excel is to use the UNIQUE function. This function returns a list of unique values from a range of cells. For example, if you have a list of names in column A, you could use the UNIQUE function to return a list of all the unique names in column A.

You can also use the PivotTable tool to get a count of unique names in Excel. To do this, select your data and then go to Insert > PivotTable. In the PivotTable dialog box, choose to create a PivotTable in a new worksheet. Then, in the PivotTable Fields dialog box, drag the Name field into the Row Labels area and drag the Count field into the Values area.