Finding unique entries in a list

  • Thread starter Thread starter Philip
  • Start date Start date
P

Philip

Hi!

I have a list of employees with activites per date. In the
form:

John Activity_A 1/1/2004
John Activity_B 1/1/2004
Ella Activity_A 1/1/2004
Tomy Activity_C 2/1/2004
Tomy Activity A 3/1/2004

Now I want to find the unique dates for each employee. In
this case John = 1. Ella = 1. Tomy = 2.

Does anyone know how to do this?

Thanks a million!
 
Back
Top