You can use a formula like:
=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))
to count the number of unique entries in A1:A10.

You may want to look at Chip Pearson's site. He has lots of techniques to work
with duplicates:
http://www.cpearson.com/excel/Duplicates.aspx


matt3542 wrote:

Hi there,

I am trying to count the number of values in a column (A2:A217) ignoring
duplicated values. As an eg, applying this to the data below I would expect
the count value to be 3. Please can anyone help, many thanks, Matt

00013270
00018038
00018038
00018038
00018038
00018038
00018038
00018038
00018038
00018038
00018038
00023049
00023049
00023049

--

Dave Peterson