Counting text occurrences in a column

**Tony Valko** · 08-15-2014, 09:43 PM

Try this...

Let's assume you want the list of unique names to be placed in column D starting at cell D1.

Select the range of names in column A including the column header.

Goto the menu Data>Filter>Advanced
Select: Copy to another location
List range should already be entered
Copy to: D1
Select: Unique records only
Click OK

Enter this header in E1: Totals

Enter this formula in E2:

=COUNTIF(A:A,D2)

Copy down as needed.

**KaiserD2** · 08-16-2014, 08:44 AM

that worked!!! Many thanks.

Originally Posted by Tony Valko

Try this...

Let's assume you want the list of unique names to be placed in column D starting at cell D1.

Select the range of names in column A including the column header.

Goto the menu Data>Filter>Advanced
Select: Copy to another location
List range should already be entered
Copy to: D1
Select: Unique records only
Click OK

Enter this header in E1: Totals

Enter this formula in E2:

=COUNTIF(A:A,D2)

Copy down as needed.

**Tony Valko** · 08-17-2014, 09:13 AM

You're welcome. Thanks for the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.