Counting every unique text string in a column

[doctor rick]

Assume the phone book is the data base. I want to be able to count how many
people have each unique last name, from A to Z.

 

[BobT]

Use the Subtotals feature (Data Menu).

 

[Frank Kabel]

Hi
create a pivot table based on the last name column