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


--
louisp
------------------------------------------------------------------------
louisp's Profile: http://www.excelforum.com/member.php...o&userid=25880
View this thread: http://www.excelforum.com/showthread...hreadid=511929