Hi,

Am Sat, 23 Mar 2013 19:41:54 +0100 schrieb Claus Busch:

insert a pivot table. Drag the names in rows and in values.

or use advanced filter without duplicates


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2