Count Funtion

  • Thread starter Thread starter Lois
  • Start date Start date
L

Lois

How can i use the count function in Excel 2000 to count
the number of cell that contain text but not including
duplicates
 
Lois,

This Array formula, entered with Ctrl-Shift-Enter, will count the number of
unique text strings in range A1:A1000:

=INT(SUM(1/IF(ISTEXT(A1:A1000),COUNTIF(A1:A1000,A1:A1000),100000)))

Update all three A1:A1000's to reflect your actual range.

HTH,
Bernie
MS Excel MVP
 
Hi
try
=SUMPRODUCT(1/COUNTIF(A1:A100,A1:A100&""))
Note: will count also blank rows as one entry. So if you have blanks
rows in between you may subtract '1' from this formula
 
You must log in or register to reply here.

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

Counting coloured cells 3
count nonblank cells 3
Excel VBA - counting cells by colors and names to it in two different rows. 0
Counting for frequency 2
Question using countif 11
How to count merged cells 1
Counting the number of times a character occurs in a cell 1
How many functions in Excel 2003 3

Back
Top