How to count letters in excel column

Often you may want to count the number of times a word repeats in a column in Excel.

For example, suppose you have the following list of basketball team names and you’d like to count the number of repeated names:

The following examples show how to perform the following calculations:

1. Count number of times that each unique team name repeats

2. Count total repeated team names (including 1st occurrence)

3. Count total repeated team names (not including 1st occurrence)

Let’s jump in!

Example 1: Count Number of Times Each Word Repeats

To count the number of times that each unique team name repeats, we can first type the following formula into cell C2 to get a list of unique team names:

Next, we can type the following formula into cell D2 to count the number of times each team name repeats:

Column D now shows the number of times that each unique team name occurs.

Example 2: Count Total Repeated Words (Including 1st Occurrence)

To count the total number of repeats (including the 1st occurr

how to count duplicate text in excel

how to count repeated text in excel