On Mon, 13 Feb 2006 15:08:13 -0600, louisp
wrote:


hello,

Here is a sample of data that I have:

CODE NAME LASTNAME
TS19 Sylvain Brook
TS19 Sylvain Brook
TV04 Valérie Musoni
TV04 Valérie Musoni
VB05 Ben Valiquette
VB05 Ben Valiquette
VB05 Ben Valiquette
VI02 Isabelle Vanasse
VR07 Richard Vivo
VR07 Richard Vivo
VR07 Richard Vivo
WD01 Dany Williams
WD01 Dany Williams
WD01 Dany Williams

How can I quickly get the total number of employees from a list like
this one? the first field is a unique key (1 code per employee)

In this case, the desired result would be 6. (the count function does
NOT give the desired result..)

thank you!!

louisp


Download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr/forums

Then use the formula:

=COUNTDIFF(CODE)

where CODE represents the range containing the Employee key


--ron