Counting

  • Thread starter Thread starter shaggy56
  • Start date Start date
S

shaggy56

How do I count the number of entries in a column so that duplicat
entries are only counted once
 
Hi

If you have a look at Chip Pearson's web site
(http://www.cpearson.com/excel/duplicat.htm) you will find the following:
---
Counting Unique Entries In A Range
To count the number of unique entries in the list, use the following array
formula:

=SUM(IF(FREQUENCY(IF(LEN(Range1)>0,MATCH(Range1,Range1,0),""),
IF(LEN(Range1)>0,MATCH(Range1,Range1,0),""))>0,1))

This will return the number of unique entries in Range1. It will not count
blanks at all.

---

(array formulas need to be entered using Ctrl + Shift + Enter not just
Enter)

you might like to have a look at his site as there are more details there on
just about anything to do with duplicates.


Regards

JulieD
 
One way:

=SUMPRODUCT((A1:A100<>"")/COUNTIF(A1:A100,A1:A100&""))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


How do I count the number of entries in a column so that duplicate
entries are only counted once?
 
Back
Top