Hello

Can someone tell me the best way to set up a spread sheet. that will log peoples names and an activity that they have chosen for an after school club. But i need there to be a coloum that automaticaly brings up names that apear more than once.

Thankyou