View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
James James is offline
external usenet poster
 
Posts: 542
Default Count the number of names in a column

I have a worksheet that lists names in one column. Is there a formula that'll
calculate the number of people represented? For example, column A lists:

Fred
Tony
Fred
Fred
Max

The five cells represent 3 people. I'm looking for a formula that'll tell me
the list represents 3 people.

Thanks for your help!