Counting Instances of Text

  • Thread starter Thread starter dhil
  • Start date Start date
D

dhil

Greetings Excel Community,

I have a counting issue that I have not been able to resolve. I have a
large spreadsheet of 800+ rows. One of the columns contains names.
The names may occur more than once (e.g., there may be 15 rows
with the name "John Smith").

My question is: how can I count how many different names occur
over the course of the entire spreadsheet? The end result would be
a number detailing the number of unique names in the worksheet.

Thanks in advance,
Daniel
 
If unique items are in range A2:A100 then

=SUMPRODUCT(1/COUNTIF(A2:A100,A2:A100))

HTH
Kostis Vezerides
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional count 2
counting repeats. 8
Count unique with multiple criteria 3
How can I count unique values 7
Function in Excel to count and list number of entries of text valuesin a row. 2
Conditioanl Sum Help with Multiple Sheets in a Workbook 4
Counting Individuals not Occurrences in Excel 2007 2
Counting unique values by date 10

Back
Top