Counting every unique text string in a column
 

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.

Use the Subtotals feature (Data Menu).

"doctor rick" wrote:

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.

Hi
create a pivot table based on the last name column

--
Regards
Frank Kabel
Frankfurt, Germany

doctor rick wrote:
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.