Does anyone know a formula that can list names under a specific category? If there is how can i get the duplicate names enter as one under that specific category?

eg

lIST
stark:
Supervisor
SuperVisor
John
EDMA
Correct List

Stark:
Supervisor=2
John=1
Edma=1

Anyone?